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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
