MySQL Forums
Forum List  »  Microsoft SQL Server

Re: SQL Server to MySQL
Posted by: Robin Oaks
Date: January 11, 2013 02:10PM

Thank you Sergio, that issue was fixed. I have another one:

Even though the create table script defines a field as tinyint unsigned, when it batch copies records into the table, it will not copy a value greater than 127 (the max for a signed tinyint). Thus, throwing an exception and not copying that batch and subsequent batches of records. Should I report this one as a bug.

Also, as a work around, I tried to upgrade the datatype to a smallint, but it threw an exception stating it was an type mismatch. Does it not cast up?

Have a nice day,
Robin



Edited 1 time(s). Last edit at 01/11/2013 02:27PM by Robin Oaks.

Options: ReplyQuote


Subject
Written By
Posted
January 10, 2013 01:58PM
January 11, 2013 10:34AM
Re: SQL Server to MySQL
January 11, 2013 02:10PM


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.