Solved

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

Posted on 2009-05-12
5
991 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 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