MySQL Forums
Forum List  »  Microsoft SQL Server

migrate from SQL Server 2005 to MySql 5.1.39
Posted by: gioia guiducci
Date: May 08, 2013 03:13AM

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

Options: ReplyQuote

Written By
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.