Thread: Migration from MySQL

Migration from MySQL

From
"Glauter Moulin Coelho"
Date:
Hi,
 
Does anyone knows some tool to migrate data from MySQL to PostgreSQL WIN ?
 
Regards.

Re: Migration from MySQL

From
Sean Davis
Date:
On May 25, 2005, at 10:40 AM, Glauter Moulin Coelho wrote:

> Hi,
>  
> Does anyone knows some tool to migrate data from MySQL to PostgreSQL
> WIN ?
>  
> Regards.

Look at SQL::Translator, a perl module for migrating schema.

Sean


Re: Migration from MySQL

From
"Van Ingen, Lane"
Date:
I attached a checklist of items that we found had to be addressed when we converted from MySQL to PostgreSQL. Some of
theseconcern the data itself, not just the schema.
 
 
I don't know if SQL::Translator does all of this; if not, hope it helps you out! Some of the items in the list are the
waywe handled things here, so use or ignore those.
 

    -----Original Message----- 
    From: pgsql-novice-owner@postgresql.org on behalf of Sean Davis 
    Sent: Wed 5/25/2005 11:45 AM 
    To: Glauter Moulin Coelho 
    Cc: pgsql-novice@postgresql.org 
    Subject: Re: [NOVICE] Migration from MySQL
    
    


    On May 25, 2005, at 10:40 AM, Glauter Moulin Coelho wrote:
    
    > Hi,
    >  
    > Does anyone knows some tool to migrate data from MySQL to PostgreSQL
    > WIN ?
    >  
    > Regards.
    
    Look at SQL::Translator, a perl module for migrating schema.
    
    Sean
    
    
    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
        (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
    


Attachment

Re: Migration from MySQL

From
Volkan YAZICI
Date:
Hi,

On 5/25/05, Glauter Moulin Coelho <gerente@gerente.com.br> wrote:
> Does anyone knows some tool to migrate data from
> MySQL to PostgreSQL WIN ?

{{{ $ cat contrib/mysql/README.mysql
Here are two conversion utilities for MySQL dumps.  Use the one you prefer.

The most recent version of my2pg.pl can be obtained from:

        http://www.omnistarinc.com/~fonin/downloads.php#my2pg

my2pg.diff has additional changes for CREATE FUNCTION.

Another tool, mysql2pgsql, can be found at:

        http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
}}}

Regards.

Re: Migration from MySQL

From
"Glauter Moulin Coelho"
Date:
Thank you all !

----- Original Message -----
From: "Volkan YAZICI" <volkan.yazici@gmail.com>
To: "Glauter Moulin Coelho" <gerente@gerente.com.br>
Cc: <pgsql-novice@postgresql.org>
Sent: Wednesday, May 25, 2005 2:17 PM
Subject: Re: [NOVICE] Migration from MySQL


Hi,

On 5/25/05, Glauter Moulin Coelho <gerente@gerente.com.br> wrote:
> Does anyone knows some tool to migrate data from
> MySQL to PostgreSQL WIN ?

{{{ $ cat contrib/mysql/README.mysql
Here are two conversion utilities for MySQL dumps.  Use the one you prefer.

The most recent version of my2pg.pl can be obtained from:

        http://www.omnistarinc.com/~fonin/downloads.php#my2pg

my2pg.diff has additional changes for CREATE FUNCTION.

Another tool, mysql2pgsql, can be found at:

        http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
}}}

Regards.