Migration from PervasiveSQL - Mailing list pgsql-general

From Collin
Subject Migration from PervasiveSQL
Date
Msg-id 46F2A819.1040700@kkmfg.com
Whole thread Raw
Responses Re: Migration from PervasiveSQL
Re: Migration from PervasiveSQL
List pgsql-general
Well, the subject says it pretty well but to elaborate:

I have a database from our ERP package that uses btrieve (PervasiveSQL)
for it's database engine. I'd like to transition all of the data to
PostgreSQL. I've been having trouble finding a suitable program to
automatically get all of the data transferred over.

I have the proper DDF files and an ODBC link in place to the data.
Maestro DataDump (from the Postgresql Data Wizard program) only locks my
machine up and it seemed to be the only think I could find that would
take an ODBC link to the btrieve data and use it to extract the table
defs and data to postgresql. Is there some other utility I could use or
am I stuck writing a custom program to do it? I could maybe extract the
btrieve data to CSV files but I don't have any easy way of doing that
quickly for so many tables (and there are a lot!)

Any help would be appreciated. Thanks!

pgsql-general by date:

Previous
From: Dániel Dénes
Date:
Subject: Query planner unaware of possibly best plan
Next
From: Bill Moran
Date:
Subject: Re: autovacuum