Migration from FoxPro - Mailing list pgsql-hackers

From P. Dwayne Miller
Subject Migration from FoxPro
Date
Msg-id 3B265302.428C320B@espgroup.net
Whole thread Raw
Responses Re: Migration from FoxPro  (reinoud@xs4all.nl (Reinoud van Leeuwen))
List pgsql-hackers
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?



pgsql-hackers by date:

Previous
From: Limin Liu
Date:
Subject: Big5 contains '\'
Next
From: Bruce Momjian
Date:
Subject: Re: Improving pg_hba.conf