Copy Image field to other DB - DTS Doubles File Size!

[sipps]

Hi all,

I've got one database with a table which holds a lot of documents in binary format (Image) in SQL 2000.

I have used DTS to transfer this table into another database table and when the files are retrieved from this DB, they have doubled in size!

Now I have read somewhere that when Image columns are transferred, SQL 2000 converts the field to varchar which doubles the length due to the character set? and then inserts this into the other table as a blob.

Please could anyone shed any light on this problem as it's eating up storage space and bandwidth for downloading these documents!

Cheers

 

[NoCoolHandle]

What is double? Are the dpages getting bigger or are you looking at the database size?
And is that the mdf file or the output of sp_spaceused?

SQL likes to "log" inserts. So 1 gig of images = 1 gig of log space. = 2 gigs of sp_spaceused


Rob

 

[sipps]

The actual file stored in the database field is doubling in size. So in Database A, the PDF document is 1Mb. I copy the entire table to Database B, view the same document and it is now 2Mb.

Cheers