Bug #66584 SQLServer Text column mapped to Varchar(16)
Submitted: 28 Aug 2012 21:04 Modified: 20 Sep 2012 7:08
Reporter: Andre Bechara Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:5.2.42 CE OS:Windows (7 Home Basic)
Assigned to: CPU Architecture:Any
Tags: migration, SQLServer

[28 Aug 2012 21:04] Andre Bechara 
Description:
When a table from SQLServer is migrated to MySQL using Workbench, text columns were mapped to varchar(16). 

How to repeat:
1- Create a table on SQLServer with a column of text data type.
2- Run the migration tool on workbench
3- Check table description on MySQL

Suggested fix:
Map to Text data type on MySQL
[29 Aug 2012 15:09] MySQL Verification Team 
Thank you for the bug report.
[20 Sep 2012 7:08] Philip Olson 
Fixed as of the upcoming MySQL Workbench 5.2.44, and here's the changelog entry:

 When a table from Microsoft SQL Server was migrated to MySQL,
 "TEXT" columns were mapped to "VARCHAR(16)". They are now mapped 
 to "LONGTEXT" because Microsoft SQL Server "TEXT" columns have a 
 maximum length of "2^31 - 1".

Thank you for the bug report.