MySQL Forums
Forum List  »  Microsoft SQL Server

Migrating images from MS SQL to Mysql
Posted by: Shilpa Monika
Date: July 11, 2013 02:10AM

Hi... I need to migrate image data in MS SQL 2008 R2 to MySQL 5.5.
I'm able to dump images in .csv file thru bcp command but when loading it into MYSQL, image is showing but distorted.
Any idea what can be the issue? Collation/charset issue ?
bcp command used: bcp tablename out filename.
Also I made sure the 4bytes added by bcp to image data is not happening by not giving -n in bcp command.

Please help

Options: ReplyQuote

Written By
Migrating images from MS SQL to Mysql
July 11, 2013 02:10AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.