Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Migration warnings - Truncated key column length for column x to x - SQL Server to MYSQL Migration

I am using the migration wizard provided by MySQL workbench 6.3 to convert a SQL Server database into a MySQL. I tested the connection between both DBs and they are valid for the migration wizard. Once The migration wizard has completed I am left with 22 migration warnings and they are all the same warning:

Truncated key column length for column 0 to 16

I am having a hard time finding any similarities between the tables that are receiving warnings to narrow down the issue. There are tables with the same types of data that are not receiving these errors.

Here is an example of one of the tables affected by this warning.

enter image description here

Does anyone know what is/what could be causing these migration warnings?

if you need more information/images please let me know.

like image 965
Altef four Avatar asked Dec 09 '15 19:12

Altef four


1 Answers

Migration wizard show this warning when find index that have different length on source and target databases. In fact you should also get index name in that message - ... for column <name> from ..., but it's empty. I guess something goes wrong, but to investigate that I need to reproduce issue on my machine. Please fill bug report on bugs.mysql.com and attach there sample database (you can make it private if you wish). Then paste link here.

like image 172
Milosz Bodzek Avatar answered Nov 15 '22 08:11

Milosz Bodzek