Thread

1. Migrating from MySQL

   Rohit Coder <passionate_programmer@hotmail.com> — 2010-06-27T06:22:09Z

   I want to migrate a production MySQL database to PostgreSQL. Is there any free tool that works effectively?
   
   I downloaded PostgreSQL plus advanced server from EnterpriseDB website. Should I go with the original community PGSQL edition or EnterpriseDB edition?
   
   Regards,
   Rohit Prakash
    		 	   		  
   _________________________________________________________________
   Bollywood This Decade
   http://entertainment.in.msn.com/bollywoodthisdecade/

2. Re: Migrating from MySQL

   Alex Hunsaker <badalex@gmail.com> — 2010-06-27T06:38:45Z

   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
   
   

3. Re: Migrating from MySQL

   John R Pierce <pierce@hogranch.com> — 2010-06-27T06:48:37Z

   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.
   
   
   
   
   
   

4. Re: Migrating from MySQL

   Jacqui Caren <jacqui.caren@ntlworld.com> — 2010-06-29T14:30:34Z

   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
   
   

5. Re: Migrating from MySQL

   Adrian von Bidder <avbidder@fortytwo.ch> — 2010-06-30T06:09:34Z

   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)