Migration from MySQL to PostgreSQL : Datatypes?

Поиск
Список
Период
Сортировка
От Bill P.
Тема Migration from MySQL to PostgreSQL : Datatypes?
Дата
Msg-id 519807.85107.qm@web65803.mail.ac4.yahoo.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Benjamin Golder
Дата:
Сообщение: super beginner setting up postgresql for the first time
Следующее
От: Richard Broersma
Дата:
Сообщение: Re: super beginner setting up postgresql for the first time