Re: Migration from MySQL to PostgreSQL : Datatypes? - Mailing list pgsql-novice

From Mladen Gogala
Subject Re: Migration from MySQL to PostgreSQL : Datatypes?
Date
Msg-id 4D140F5F.6090207@vmsinfo.com
Whole thread Raw
In response to Re: Migration from MySQL to PostgreSQL : Datatypes?  ("Bill P." <maxarbos@yahoo.com>)
Responses Re: Migration from MySQL to PostgreSQL : Datatypes?
Re: Migration from MySQL to PostgreSQL : Datatypes?
List pgsql-novice
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


pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: super beginner setting up postgresql for the first time
Next
From: Jayadevan M
Date:
Subject: Re: Migration from MySQL to PostgreSQL : Datatypes?