?
Solved

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

Posted on 2009-05-12
5
Medium Priority
?
1,032 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 2000 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 2000 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

762 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