Re: Converting a Simple Database from MySQL to PostgreSQL in 40 hours?

On Thu, Jun 24, 2010 at 03:41:08PM -0700, 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?

This depends on a great many factors including:

* The size of the data
* What it's currently stored on for MySQL (a single slow spindle with a couple of TB on it may take time)
* What it will be stored on for PostgreSQL
* What MySQL idioms won't translate directly to PostgreSQL

Generally, getting the schema and data moved over are the first two
steps in a much longer process, wherein all the apps use the database
as an active database rather than a passive one, the latter being all
MySQL really allows.

Hope this helps :)

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate