Re: Migration from PervasiveSQL - Mailing list pgsql-general

From Robert Treat
Subject Re: Migration from PervasiveSQL
Date
Msg-id 200709241140.57346.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Migration from PervasiveSQL  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
Responses Re: Migration from PervasiveSQL
List 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@users.sourceforge.net> wrote:
> > > > On Thursday 20 September 2007 18:38, Merlin Moncure wrote:
> > > > > On 9/20/07, Collin <adderd@kkmfg.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DELETE FROM pg_class
Next
From: Vivek Khera
Date:
Subject: Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER