Re: Migration from PervasiveSQL

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Collin <adderd(at)kkmfg(dot)com>
Subject: Re: Migration from PervasiveSQL
Date: 2007-09-24 15:40:56
Message-ID: 200709241140.57346.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday 23 September 2007 23:43, Ow Mun Heng wrote:
> On Sat, 2007-09-22 at 16:05 -0400, Robert Treat wrote:
> > 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:
> > > > >
> > > > > 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.
>
> What about Perl? DBI? Not sure if it supports PervasiveSQL
>

The OP stated he already had ODBC connectors setup.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2007-09-24 15:45:39 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Previous Message Tom Lane 2007-09-24 15:06:31 Re: DELETE FROM pg_class