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 _______________________________________________ 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]
