Migrating from MySQL

On Sun, Jun 27, 2010 at 00:22, RP Khare
<passionate_programmer@hotmail.com> wrote:

I want to migrate a production MySQL database to PostgreSQL. Is there any
free tool that works effectively?

I'd start here:
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL

On 06/26/10 11:22 PM, RP Khare wrote:

I downloaded PostgreSQL plus advanced server from EnterpriseDB
website. Should I go with the original community PGSQL edition or
EnterpriseDB edition?

thats entirely up to your preferences and needs. Personally, I think
that the standard PostgreSQL would more than suffice as a MySQL
replacement. I thought most of the EntepriseDB specific features were
oriented around Oracle database compatibility.

John R Pierce wrote:

On 06/26/10 11:22 PM, RP Khare wrote:

I downloaded PostgreSQL plus advanced server from EnterpriseDB
website. Should I go with the original community PGSQL edition or
EnterpriseDB edition?

thats entirely up to your preferences and needs. Personally, I think
that the standard PostgreSQL would more than suffice as a MySQL
replacement. I thought most of the EntepriseDB specific features were
oriented around Oracle database compatibility.

See http://okbob.blogspot.com/2009/08/mysql-functions-for-postgresql.html?showComment=1250968406041

Heyho!

On Sunday 27 June 2010 08.22:09 RP Khare wrote:

I downloaded PostgreSQL plus advanced server from EnterpriseDB website.
Should I go with the original community PGSQL edition or EnterpriseDB
edition?

If you work on a Linux/BSD/... OS distribution with a sane package manager,
I always try to work with the version that comes with the distribution: you
won't have to care about security updates and the like, they'll just come in
with the OS updates.

Of course, on Windows (and commercial Unices?), you don't have that choice.

cheers
-- vbi

--
Could this mail be a fake? (Answer: No! - http://fortytwo.ch/gpg/intro)