Re: Migration from PervasiveSQL

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, Collin <adderd(at)kkmfg(dot)com>
Subject: Re: Migration from PervasiveSQL
Date: 2007-09-22 02:43:45
Message-ID: b42b73150709211943j476d9348u160ebf541f871e1e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

:-)

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-22 03:50:44 Re: SPI shared memory ?
Previous Message Robert Treat 2007-09-22 02:05:00 Re: Migration from PervasiveSQL