migrate from SQL Server 2005 to MySql 5.1.39
Hi, i have to migrate a database from MS Sql Server 2005 to Mysql 5.1.39.
I first tried to migrate a table . In this table there is a field whit this definition : [ [id] [numeric](19, 0) IDENTITY(1,1) NOT NULL] . The Workbench proposes me this conversion: [`id` DECIMAL(19,0) NOT NULL ].
If I use this definition the copy is performed successfully, but I have to migrate to this definition [ `id` BIGINT(20) NOT NULL AUTO_INCREMENT ].
If I use this second definition I have an error in the copy data phase:
ERROR: `ALFRESCO_TEST`.`alf_qname`:Type mismatch fetching field 1 (should be string, was MYSQL_TYPE_LONGLONG)
Why ? Is it possible make this target definition ?
Thanks for the help
Subject
Written By
Posted
migrate from SQL Server 2005 to MySql 5.1.39
May 08, 2013 03:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.