Skip site navigation (1) Skip section navigation (2)

Re: Migration from MySQL to PostgreSQL : Datatypes?

From: Aarni <aarni(at)kymi(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: "Bill P(dot)" <maxarbos(at)yahoo(dot)com>
Subject: Re: Migration from MySQL to PostgreSQL : Datatypes?
Date: 2010-12-23 17:38:47
Message-ID: 201012231938.47223.aarni@kymi.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thursday 23 December 2010 19:12:18 Bill P. wrote:
> Hello,
> 
> What would be the best way to deal with migrating a database structure and
>  data from a mysql db to postgres when there are dataypes in the mysql
>  tables that are not present, and thus throw errors using the current
>  migration wizard, in postgres?
> 
> If i leave these few tables out on first import, many of the other tables
>  that these few key back to dont get created either.
> 
> I found a program called easyfrom, but it's over $200 and only runs on
>  windows. Navicat, which i have, doesnt seem to have any provision to
>  change the datatypes on structure sync from one to the other types of db.
> 
> Any suggestions would be great.
> thanks.
> 

Hello,

I don't know about the best way but I have recently used this perl script 
quite succesfully. It's 'old' but nevertheless, it worked. 

http://pgfoundry.org/projects/mysql2pgsql/

BR and Merry Christmas!

-- 
Aarni Ruuhimäki
--------------
This is a bug-free broadcast from Ubuntu 9.10
Karmic Koala Linux System

PROUD TO BE 100% Microsoft FREE!

In response to

pgsql-novice by date

Next:From: Richard BroersmaDate: 2010-12-23 17:38:50
Subject: Re: Migration from MySQL to PostgreSQL : Datatypes?
Previous:From: Richard BroersmaDate: 2010-12-23 17:17:29
Subject: Re: super beginner setting up postgresql for the first time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group