Re: Migration from MySQL to PostgreSQL : Datatypes?

Bill P. wrote:
> Thanks for all the responses so far.
>
> I can get the data in it seems with no problem, but I refuse to
> believe that I need create all the tables manually
Actually, you don't, but the trick is not for the faint hearted. I did
migrate one MySQL schema to Postgres, but used Oracle RDBMS as an
intermediate step. Oracle Corp. has a great tool for migrating MySQL to
Oracle. Once there, you can use a phenomenal ora2pg script to migrate
the schema from Oracle --> PostgreSQL. Oracle RDBMS is, of course, not
free.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com