From: | Aarni <aarni(at)kymi(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | "Bill P(dot)" <maxarbos(at)yahoo(dot)com> |
Subject: | Re: Migration from MySQL to PostgreSQL : Datatypes? |
Date: | 2010-12-23 17:38:47 |
Message-ID: | 201012231938.47223.aarni@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2010-12-23 17:38:50 | Re: Migration from MySQL to PostgreSQL : Datatypes? |
Previous Message | Richard Broersma | 2010-12-23 17:17:29 | Re: super beginner setting up postgresql for the first time |