Solved

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

Posted on 2009-05-12
5
1,005 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

761 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