|
Michelle, On 12/24/2017 1:20 PM, Michelle Konzack wrote: 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, Igal Sapir
|
