On Tue, 12 Jun 2001 13:36:02 -0400, you wrote:
>Anyone know of any alternatives to using pgAdmin to migrate a database
>(schema and data) from Foxpro to PostgreSQL? pgAdmin worked fine on my
>initial test database, but it was slow... very slow. I'd like to try to
>migrate one of our production databases, where several tables have
>200,000+ records each. I can export the data into a PG COPY friendly
>format, but was wondering if anyone knew of a tool that would migrate
>all of the primary keys and indexes too? Or a perl utility that would
>read the Foxpro database and generate the SQL commands needed to create
>the tables and indexes?
>
(assuming you use some windows version :-)
- Download the Powerdesigner 45 day trial from www.sybase.com
- make an ODBC connection to your database
- reverse engineer the datamodel
- change the target model to postgresql
- install postgresql odbc drivers
- generate a database creation script and execute it through the ODBC
connection
- create a report of your database for your documentation :-)
--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen reinoud@xs4all.nl
http://www.xs4all.nl/~reinoud
__________________________________________________