Re: Scheme conversion MySQL to PGSQL

Hello Igal

Am 2017-12-24 hackte Igal @ Lucee.org in die Tasten:

I am doing a similar thing migrating from SQL Server, and I am
considering to publish an open source Migrator.

Can you tell me about some of the data types that you had to change
moving from MySQL to Postgres?

I convert only those four CREATE TABLE from mySQL to pgSQL which
is the forum pluging for squirrelmail.

auto_increment  ->   serial
int(NN)         ->   int
datetime        ->   timestamptz  (attention:  it is NOT timestamp)
longtext        ->   text

Thank you.  My migration tool (written in Java) already supports migrating a SQL Server database to Postgres with most data types.

Perhaps I will improve it further when I have some more time to support MySQL source databases as well, in which case I will use the information that you sent as a starting point.

Best,