From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Converting a Simple Database from MySQL to PostgreSQL in 40 hours? |
Date: | 2010-06-24 23:02:40 |
Message-ID: | 20100624230240.GO1474@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Wang, Mary Y | 2010-06-24 23:04:42 | Need Some Recent Information on the Differences between Postgres and MySql |
Previous Message | Wang, Mary Y | 2010-06-24 22:41:08 | Converting a Simple Database from MySQL to PostgreSQL in 40 hours? |