Re: Migration from MySQL to PostgreSQL : Datatypes?

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: "Bill P(dot)" <maxarbos(at)yahoo(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Migration from MySQL to PostgreSQL : Datatypes?
Date: 2010-12-24 03:11:27
Message-ID: 4D140F5F.6090207@vmsinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jayadevan M 2010-12-24 03:26:26 Re: Migration from MySQL to PostgreSQL : Datatypes?
Previous Message John DeSoi 2010-12-24 02:41:51 Re: super beginner setting up postgresql for the first time