Re: Migration from PervasiveSQL

On 9/20/07, Collin <adderd@kkmfg.com> wrote:
> 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!)

dump to csv would be ideal (you could then use the built in csv import
through pg via COPY).

barring that you need to roll some scripts or use a tool.  There are
many ways to do this of varying quality, mostly pretty dubious.  In
the microsoft world you have DTS which has an ok migrator.

merlin