Re: Migration from PervasiveSQL

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, <pgsql-general(at)postgresql(dot)org>
Cc: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Collin" <adderd(at)kkmfg(dot)com>
Subject: Re: Migration from PervasiveSQL
Date: 2007-09-25 02:25:50
Message-ID: 015801c7ff1b$641d2520$c601a8c0@HP22720319231
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

Sorry, very late reaction...

----- Original Message -----
From: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>

> 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/

Thanks great information.:-)

>>
>> Development Status: 1 - Planning
>>
>> :-)

Yes, I'm the stage which has searched the figure which should desire it.
I see the figure of the application business used realized with two or more
databases. Then, I have explored the solution method which does not spoil
those property. Probably, ORACLE, DB2, SQLServer, and PostgreSQL
live together. On that occasion, They wish data to flow smoothly between
those databases. However, Now odbclink has not equipped cursor yet....

>
> *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.

I progress little by little. It seems to be a tortoise completely.:-)

Thanks.!

Regards,
Hiroshi Saito

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anoo Sivadasan Pillai 2007-09-25 04:27:57 Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
Previous Message Tatsuo Ishii 2007-09-25 01:23:58 Re: about pgpool question