Bug #14328 Wront convertion of tinyint from mssql 2000
Submitted: 26 Oct 2005 11:36 Modified: 19 Feb 2006 16:58
Reporter: Christian Wagner Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.20rd OS:Windows (Windows 2000 Server)
Assigned to: CPU Architecture:Any

[26 Oct 2005 11:36] Christian Wagner 
Description:
We tried to migrate a Database from a MS SQL Server 2000 to a MySQL Server 5.0.15.
Everything did well if there was no tinyint used in the table. Because MS Sql uses tinyint as unsign as default and the migrationtool set the tinyint not unsigned (->signed ;)) so on filling data into the table it doesn't work because the data gets auf of range.

How to repeat:
Go to your table preferences and mark your tinyints as unsigned. But this really sucks if you have more tables with much tinyints used. Another way is to write a small script to handle this.

Suggested fix:
The migration toolkit needs to convert tinyint unsigned if they are unsigned in ms sql server
[9 Jan 2006 14:57] Aleksey Kishkin 
It's not a feature request but rather bugreport. Changing severity to S3
[19 Jan 2006 16:58] Valeriy Kravchuk 
Please, try to repeat with version 1.0.22 now availabe and inform about the results.
[20 Feb 2006 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".