• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1052
  • Last Modified:

MEDIUMBLOB INSERT from Migration Toolkit script (MS SQL to MySQL migration)

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:
, 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?
0
VFPSQLDeveloper
Asked:
VFPSQLDeveloper
  • 2
2 Solutions
 
NerdsOfTechTechnology ScientistCommented:
First try this:

The Migration Toolkit must be installed to the default of:

C:\Program Files\MySQL\MySQL Migration Toolkit 1.0

... Or else the blob migration may fail
0
 
VFPSQLDeveloperAuthor Commented:
Hi NerdsOfTech,

Sorry for the delay in getting back to this - other things have taken a priority.

I dont have the 'C:\Program Files\MySQL\MySQL Migration Toolkit 1.0 ' folder so I looked in Add/Remove Programs to uninstall it so I could re-install in this folder and the Migration Toolkit doesnt exist as an entry in it's own right.

Could it be part of 'MySQL Tools for 5.0'?
0
 
NerdsOfTechTechnology ScientistCommented:
Correct, it is the MySQLTools 5.0.

Reinstall in that directory. (I think it is default?)
C:\Program Files\MySQL\MySQL Migration Toolkit ...

Also, I am posting the link to the newest migration kit page to you just in case he doesn't have the current version of the mySQL migration kit.

http://dev.mysql.com/downloads/gui-tools/5.0.html

0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now