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

SQL Data Compare 9 - Comparing Different Datatypes

I am trying to compare several different datatypes, such as nvarchar to numeric. I checked the table from the link below and it is a supported data type comparison but SQL Data Compare says it is not. Here is a sample of what I am talking about.

Any help would be much appreciate.

http://www.ericdrobny.com/sites/default/files/public/SQLDataCompare.jpg

http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/help/9.0/SDC_Which_Data_Types_Can_Be_Compared
edrobny
0

Comments

1 comment

Sort by
  • edrobny
    I received the following response from support:
    Thank you for your support request and thank you for bringing this issue to our attention.

    I was able to replicate the issue using SQL Data Comnpare v9.1.0.365 and the new V10.0.1.119

    I suspect that the documentation is incorrect and the product is working correctly, as personally I would not expect that you would be able to match nvarchar datatype to numeric datatype.

    I have submitted a bug report to the SQL Data Compare Development Team to bring this issue to their attention. The reference for this bug report is SDC-1325.

    Once again, thank you for bringing this issue to our attention. Sadly, I do not have a work around for the issue to offer at this time.
    edrobny
    0

Add comment

Please sign in to leave a comment.