Re: Migrating PostgreSQL database to MySQL/MS Access - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Migrating PostgreSQL database to MySQL/MS Access
Date
Msg-id b42b73150608121248l7609aa6ag29d7b1a41fb7f250@mail.gmail.com
Whole thread Raw
In response to Re: Migrating PostgreSQL database to MySQL/MS Access  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: Migrating PostgreSQL database to MySQL/MS Access  ("Jaime Casanova" <systemguards@gmail.com>)
List pgsql-general
On 8/12/06, Bill Moran <wmoran@collaborativefusion.com> wrote:
> RPK <rohitprakash123@indiatimes.com> wrote:
>
> >
> > How can I migrate a PostgreSQL database to MySQL or MS Access?

in your case i would suggest ms dts or vb script in conjunction with
the odbc driver for both databases.

> You can't.  Neither MySQL nor Access support the advanced features in
> PostgreSQL.  You'll probably have to rewrite the app.

well, since he wrote his app in vb.net he is probably using postgresql
as a dumb data store, it might not be all that difficult. still, not a
very smart move.

merlin

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Deploying app. using PostgreSQL
Next
From: "Merlin Moncure"
Date:
Subject: Re: Automatic Backup Script