Does DataCompare compare text and image datatypes

stiej1977

Has anyone ever experienced problems in comparing the data in two tables that contain a text or image datatype? Does DataCompare handle these as reliably as other datatypes?

Thanks

Brian Donahue

Thanks for your post. Comparing BLOB types such as TEXT and IMAGE is as easy as comparing any other datatype. The obvious difference would be performance -- getting this type of data could potentially be slower because of the way SQL Server stores it.

The only 'gotcha' that I know of could happen if you specify a WHERE clause selecting from a second table and an update function is generated for it.