SQL Server varbinary(max) to Image data type

Question

I've got a database table that stores images as varbinary(max). This works great for me. However, I have to now send this data to a MS Dynamics database that will have to use the Image data type.

Is there anything I need to be aware of when saving varbinary(max) to image? Can my data become corrupted, or are they generally the same datatype for all intents and purposes?

Thanks

Answer 1

They are the same thing and handled the same internaly. They droped the image name because it dosn't really make sense. Its not like sqlserver can do image operations in tsql