Friday, March 23, 2012

Importing MySQL BLOB to MSSQL

Hi all!
I'm trying importing a MySQL database to my MSSQL server. I've donwloaded the MySQL ODBC drivers and I can connect succesfully throught a DSN to my MySQL server. Everything works fine EXEPT my BLOB field. I'm using a BLOB field for storing a binary file.

When I choose preview while importing my bob field is empty.

I'm desperate!

:eek:Viewing a BLOB is pretty much a waste of time. Use DTS or a linked server to move it, and life should be good.

-PatP

No comments:

Post a Comment