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!
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? |