On Saturday 31 March 2007 18:08, [EMAIL PROTECTED] wrote: > I also would like some ideas on good stuff to help me get up to speed with > PostgresSQL. i.e. What would be a quick way to migrate/recreate my present > database in VFP to PosgresSQL? Would it make sense to write a VFP app to > read the VFP database structure and recreate it in PostgresSQL? > > Personally I think it would be more productive to do it the other way.. > i.e. from PostgresSQL, reads VFP structures and creates it in PostgresSQL. > That way I would be learning how to do something in PostgresSQL not in > fox.
To transfer data from DBF's to Postgres I use a product from EMS. I have forgotten what it cost but some where around $100. I also had a simple VFP prg that grabbed the DBF structure and created the SQL for Postgres but it did not help with data much. Working from the Postgres side (I think that's what you mean) the steps are very easy. 1. create the tables 2. export the VFP tables to txt limited 3. use postgres's COPY command to import the data You will be very surprised how fast the copy command works. In my case I was able to copy close to a gig in under a min. I don't know that is even possible but I did it several times (because I figured something had to be wrong). Make sure you have not setup any indexes on the Postgres side prior to importing. -- 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/dabo-users/[EMAIL PROTECTED]
