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?
Re: Migration from MySQL to PostgreSQL : Datatypes? Re: Migration from MySQL to PostgreSQL : Datatypes? |
Список | 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.
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 по дате отправления: