How can we help you today? How can we help you today?

Does DataCompare compare text and image datatypes

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
stiej1977
0

Comments

1 comment

Sort by
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.