| From: | "Bill P(dot)" <maxarbos(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Migration from MySQL to PostgreSQL : Datatypes? |
| Date: | 2010-12-23 17:12:18 |
| Message-ID: | 519807.85107.qm@web65803.mail.ac4.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma | 2010-12-23 17:17:29 | Re: super beginner setting up postgresql for the first time |
| Previous Message | Benjamin Golder | 2010-12-23 17:05:35 | super beginner setting up postgresql for the first time |