Re: Migrating PostgreSQL database to MySQL/MS Access

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Bill Moran" <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Migrating PostgreSQL database to MySQL/MS Access
Date: 2006-08-12 19:48:38
Message-ID: b42b73150608121248l7609aa6ag29d7b1a41fb7f250@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/12/06, Bill Moran <wmoran(at)collaborativefusion(dot)com> wrote:
> RPK <rohitprakash123(at)indiatimes(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-08-12 19:50:07 Re: Automatic Backup Script
Previous Message Merlin Moncure 2006-08-12 19:45:48 Re: Deploying app. using PostgreSQL