Migration from PervasiveSQL

Поиск
Список
Период
Сортировка
От Collin
Тема Migration from PervasiveSQL
Дата
Msg-id 46F2A819.1040700@kkmfg.com
обсуждение исходный текст
Ответы Re: Migration from PervasiveSQL  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: Migration from PervasiveSQL  (nelsonsoft <nelsonsoft@nssdd.com>)
Список 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 по дате отправления:

Предыдущее
От: Dániel Dénes
Дата:
Сообщение: Query planner unaware of possibly best plan
Следующее
От: Bill Moran
Дата:
Сообщение: Re: autovacuum