On Thursday 23 December 2010 19:12:18 Bill P. wrote:
> 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.
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.
BR and Merry Christmas!
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 Broersma||Date: 2010-12-23 17:38:50|
|Subject: Re: Migration from MySQL to PostgreSQL : Datatypes?|
|Previous:||From: Richard Broersma||Date: 2010-12-23 17:17:29|
|Subject: Re: super beginner setting up postgresql for the first time|