I fiddled with lots of these tools that just didn't work. I had to convert dozens of tables from a commercial manufacturing package to postgresql - so I ended up doing it like Ed suggested - I re-created the database on a postgresql server, and used VFP to dump the table data out in delimited text files, then used a little python script to do the import from the text to posgres.
I'd really like to see a proper tool for this...there's way to much old VFP out there that will eventually need converting. On Wed, Nov 12, 2008 at 9:30 AM, johnf <[EMAIL PROTECTED]> wrote: > On Tuesday 11 November 2008 10:04:20 am KAM.covad wrote: > > I have a very large vfp9 sp1 application with 4 dbc's and hundreds of > > tables in 4 different folders, all linked into a single application. All > > tables are linked using integer primary/foreign keys. All tables get the > > next primary key from a separate 1 record table with the same name. All > the > > data entry screens use an object (scatter name) on the form as the data > > source for the textboxes. When data is entered/changed, that object is > > 'gathered' into a local view which updates the table. > > > > I would like to keep as much of this design intact as possible because it > > works well and is very easy to maintain for an application this large. > > > > I would like to convert all this to dabo/python/postgresql by 2012 if > > possible. I want to be able to run on Windows and Linux and maybe even > > Apple depending on the market. I am getting more requests from clients > > about running on Linux. > > > > Has anyone done anything like this and/or beginning to work on it? Is > there > > some 'canned' way to convert vfp9 data tables into postgresql and use the > > dabo framework so that it would allow me to view records, create some > sql, > > etc for testing? And then possibly > > create some simple data entry screens just to prove some design concepts? > > I was able to convert a large DBC using a product from 'EMS' > (www.sqlmanager.net). maybe a two hundred tables - some are very large. > When I say convert - I mean the tables. The concept of a DBC is not in > postgres (unless you concider schema's == DBC). That said - Dan Means (he > monitors the list) told me he found a way to convert DBF's to Postgres > tables. However, he didn't tell me what he used. I'm sure it was some > free > tool he found. EMS is not free. > > In the Postgres world there is the concept of a sequence. It sounds like a > direct replacement for your PK tables - easier too. > > Scatter and gather are VFP concepts that are not really required for Dabo. > In > Dabo you set the field data source and data field and Dabo handles all the > scatter and gather for you. Very simple. Updates to database are also > handled by Dabo - in again a very simple way. But I doubt you have to > consider changing your thinking in the app. Just that Dabo elimitates the > need for some of the functions. > > Most of everything available in VFP is available in Dabo. I would not say > a > direct replacement but still there. > > By 2012 Dabo will be the leader in desktop apps. No problem! > > Any chance this is an account app? > > > -- > John Fabiani > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
