Migration from PervasiveSQL

From: Collin <adderd(at)kkmfg(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Migration from PervasiveSQL
Date: 2007-09-20 17:04:25
Message-ID: 46F2A819.1040700@kkmfg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dániel Dénes 2007-09-20 17:09:13 Query planner unaware of possibly best plan
Previous Message madhtr 2007-09-20 17:01:47 How to clear bits?