Re: Migration from PervasiveSQL

On Friday 21 September 2007 22:43, Merlin Moncure wrote:
> On 9/21/07, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> wrote:
> > On Thursday 20 September 2007 18:38, Merlin Moncure wrote:
> > > On 9/20/07, Collin <adderd(at)kkmfg(dot)com> 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