MEDIUMBLOB INSERT from Migration Toolkit script (MS SQL to MySQL migration)
Posted on 2009-05-12
I'm moving a MS SQL database to MySQL and have used the migration toolkit to create the tables and the bulk transfer statements.
One of the columns in MS SQL was a varbinary(2048) and this got transposed to MEDIUMBLOB in MySQL.
The migration wizard created INSERT statements for the table containing this column with the binary data encoded like:
however, when the insert runs, it gives an error: 'Unknown column '0x' in 'field list'.
Does anyone know what I have to do to import this binary data?