On Friday 21 September 2007 22:43, Merlin Moncure wrote: > 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 > > :-) > *shrug* There's code in the scm repository if you look, and if that doesn't seem workable try emailing Hiroshi directly. I'm pretty sure you can get this wokring; Hiroshi gave a lightening talk on it at PGCon. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
