Sql Server – Blob Issue

[JasonR]

Hi

I'm doing a migration from SQL Server 2000 on Windows XP to MySQL 5.0.44 on Windows XP (same box actually). I have been using SQLyog 6.01 using the migration tool.

The migration tool seems to work very well, with all of the data being moved across. With one exception. Some data that is stored in sql server as type “image” that get mapped to a longblob in MySQL is damaged. The data is a pdf file. At some point in the data the values all just are '0', repeated all the way to the end of the file. Where the file is truncated seems to be different for each file. Maybe when it hits a certain character? There is a number of other blob fields in the same table and the database that all appear to have been copied correctly. The problem only seems to be on fields that hold pdf data.

I was able to use another tool to move the blob data over to MySQL and it appears to be valid.

I have attached both the good and bad data.

I would appreciate any advice.

Please let me know if you need more info as well.

Cheers,

Jason

[peterlaursen]

“Some data that is stored in sql server as type “image” that get mapped to a longblob in MySQL is damaged. The data is a pdf file.”

Ok .. we will have to check this with the SQL server 'image' type.

Do you mean to tell that the data on SQL Server is PDF?

Will they migrate OK if stored in a SQL server 'plain' BLOB type?

please also tell:

SQLserver version?

ODBC driver version?

[JasonR]

peterlaursen wrote on Jun 21 2007, 06:58 PM:

“Some data that is stored in sql server as type “image” that get mapped to a longblob in MySQL is damaged. The data is a pdf file.”

Ok .. we will have to check this with the SQL server 'image' type.

Do you mean to tell that the data on SQL Server is PDF?

Will they migrate OK if stored in a SQL server 'plain' BLOB type?

please also tell:

SQLserver version?

ODBC driver version?

Hi thanks for the reply.

In SQL Server, type “image” is a blob. So the only way to store a blob in SQL Server is via the image type.

The data that is in the blob is a pdf.

I have attached a create table script for both SQL Server and MySQL.

As you can see from the script there are several blob columns in the table. The only one that seems to be an issue is the combinedStatmentPdf column. The other blob columns the data appears to have been copied correctly.

SQL Server 2000, version 8.00.194

MySQL ODBC driver version 3.51 (3.51.12.0)

SQL Server ODBC driver version 2000.85.1117.00

I appreciate you taking the time to look into this.

Cheers,

Jason

[Rohit]

Can you try 6.03? We have actually fixed a blog issue recently.

[JasonR]

Rohit wrote on Jun 22 2007, 02:54 AM:

Can you try 6.03? We have actually fixed a blog issue recently.

THANK YOU! 6.03 worked. I still need to double check the results, but the data does not have the 0000 though out the file.

I had only download the the software last week, so did not think to check for an update.

Thanks again.

Cheers,

Jason

[Author]

Posts