On Saturday 31 March 2007 18:08, msavage /AT/ golden D.O.T net 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
©2007 johnf |
