Migration from MySQL to PostgreSQL : Datatypes? - Mailing list pgsql-novice

From Bill P.
Subject Migration from MySQL to PostgreSQL : Datatypes?
Date
Msg-id 519807.85107.qm@web65803.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: Migration from MySQL to PostgreSQL : Datatypes?  (Richard Broersma <richard.broersma@gmail.com>)
Re: Migration from MySQL to PostgreSQL : Datatypes?  (Aarni <aarni@kymi.com>)
Re: Migration from MySQL to PostgreSQL : Datatypes?  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-novice
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.


pgsql-novice by date:

Previous
From: Benjamin Golder
Date:
Subject: super beginner setting up postgresql for the first time
Next
From: Richard Broersma
Date:
Subject: Re: super beginner setting up postgresql for the first time