Re: Migration from MySQL to PostgreSQL : Datatypes?

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!