On 9/21/07, Robert Treat <xzilla@xxxxxxxxxxxxxxxxxxxxx> wrote: > On Thursday 20 September 2007 18:38, Merlin Moncure wrote: > > On 9/20/07, Collin <adderd@xxxxxxxxx> 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. > > > > Perhaps odbclink could be of help here? > http://odbclink.projects.postgresql.org/ Development Status: 1 - Planning :-) merlin ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
