Re: Converting a Simple Database from MySQL to PostgreSQL in 40 hours? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Converting a Simple Database from MySQL to PostgreSQL in 40 hours?
Date
Msg-id 201006241711.59192.adrian.klaver@gmail.com
Whole thread Raw
In response to Converting a Simple Database from MySQL to PostgreSQL in 40 hours?  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
List pgsql-general
On Thursday 24 June 2010 3:41:08 pm Wang, Mary Y wrote:
> Hi,
>
> My internal customer has a new project and is considering using MySQL.
> Knowing that I'm a Postgres person, the customer is open to considering
> Postgres at a later date if the cost to transition is less than 40 hours.
> The database will probably be relatively small and simple (still in the
> planning stage).  I personally think it's not possible to convert even a
> simple database from MySQL to Postgres in less than 40 hours. Has anyone
> done the conversion before? If so, what do you think?
>
>
> Please advise.
> Mary

In addition to what David said, you might want to see about getting involved in
the planning stage. I could see creating a shadow Postgres database that is
kept close to the MySQL one via some scripts. Would make the transition less
hectic. Would also give the developers some thing to work with as they went
along.

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Dann Corbit
Date:
Subject: Re: Need Some Recent Information on the Differences between Postgres and MySql
Next
From: Iwao Shikase
Date:
Subject: Re: The case of PostgreSQL on NFS Server