MySQL Forums
Forum List  »  MySQL Workbench - Database Migration

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Migration Toolkit MS SQL to MySQL VarBinary to MediumBLOB INSERT fails
Chris King
May 12, 2009 10:34AM
Re: Migration Toolkit MS SQL to MySQL VarBinary to MediumBLOB INSERT fails
Ranjeet Singh
June 24, 2009 08:12AM
Re: Migration Toolkit MS SQL to MySQL VarBinary to MediumBLOB INSERT fails
John Fitzpatrick
July 23, 2009 11:46AM


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.