Migration Toolkit MS SQL to MySQL VarBinary to MediumBLOB INSERT fails
Posted by: Chris King
Date: May 12, 2009 10:34AM

I'm moving a MS SQL Server 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: , 0x888787sdfsdf78sd7f8sd7f87sd

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?

Options: ReplyQuote


Subject
Written By
Posted
Migration Toolkit MS SQL to MySQL VarBinary to MediumBLOB INSERT fails
May 12, 2009 10:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.