Bug #31558 Migration toolkit should transform SqlServer's boolean into Bit and not TinyInt
Submitted: 12 Oct 2007 9:03 Modified: 16 Apr 2009 12:57
Reporter: Christian Cunlif Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:5.0.12 OS:Any
Assigned to: CPU Architecture:Any

[12 Oct 2007 9:03] Christian Cunlif 
Description:
The Migration toolkit should transform a MS SqlServer's boolean field into a TinyInt(1), whereas it should be a Bit(1) (or even, as I've heard, a Bool field when MySql 5.1 will be out).

This can lead to various problem, notably when reading whole datatable whose field type are deduced from the DB directly.

PS: I'm using MySQL 5.0.41 with MySql GUI Tools v5.0.r12 for windows.

How to repeat:
Create a table in SqlServer and convert it with Migration Toolkit... you get TinyInt(1) by default
[12 Oct 2007 12:42] MySQL Verification Team 
Thank you for the bug report.
[16 Apr 2009 12:57] Axel Schwenke 
Thank you for taking the time to write to us, but this is not a bug. MySQL defines a type alias BOOLEAN for TINYINT(1) and the Migration Toolkit uses it.