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