ms sql image data from my-sql

hi people

I have imported "blob" data from mysql to an ms-sql 2000 "Image" field, using ms- sql enterprise manager. However my c# image veiwer does not work on the imported blob data (it does work on data I add to ms-sql via my web application).

Is there any way I can check that the blob data creates a valid image? If anyone has any ideas of how I can debug the data coming out that would be great. Or perhaps someone can point me to somewhere I can get some help?

any pointers are much appreciated!

Greg

There is an article on migration data from Oracle Unix to SQL you might find useful http://technet.microsoft.com/en-us/library/bb497067.aspx|||

Hi,

Here's one more idea: using ADO and simple vbscript/jscript you could save the blob to a file (using the chunk or stream model for BLOBs). Then simply open the file in an image viewer.

In addition, you could use similar approach and do byte-comparison with the data from the MySQL source.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

ok thanks guys, however I think my image data was simply corrupt after all of our efforts :-)