Solved

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

Posted on 2009-05-12
5
1,017 Views
Last Modified: 2012-05-06
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
Comment
Question by:VFPSQLDeveloper
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
NerdsOfTech earned 500 total points
ID: 24469103
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
 

Author Comment

by:VFPSQLDeveloper
ID: 24494837
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
 
LVL 19

Assisted Solution

by:NerdsOfTech
NerdsOfTech earned 500 total points
ID: 24688256
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

Upcoming Webinar: Securing your MySQL/MariaDB data

Join Percona’s Chief Evangelist, Colin Charles as he presents Securing your MySQL®/MariaDB® data on Tuesday, July 11, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question