Re: Converting a Simple Database from MySQL to PostgreSQL in 40 hours?
От | David Fetter |
---|---|
Тема | Re: Converting a Simple Database from MySQL to PostgreSQL in 40 hours? |
Дата | |
Msg-id | 20100624230240.GO1474@fetter.org обсуждение исходный текст |
Ответ на | Converting a Simple Database from MySQL to PostgreSQL in 40 hours? ("Wang, Mary Y" <mary.y.wang@boeing.com>) |
Список | 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@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@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
В списке pgsql-general по дате отправления: