Comparing views in the same database

crickardcrickard Posts: 2
Is there a way to compare two view in the same database. Let's say I have View1 and View2. I would like to be able to compare matching columns in both views on a record-by-record basis. Is this possible?


  • Brian DonahueBrian Donahue Posts: 6,590 New member

    I'm afraid not. This version of SQL Data Compare only supports the comparison of one database to another. It cannot compare objects in the same database.
  • Hi there,

    check out the beta of SQL Data Compare 5. The new version will allow you to do comprehensive table and column level remappings. This will certainly allow you to achieve what is not possible in SQL Data Compare 4.

    Good luck!

    Tom Harris

    Red Gate Software
Sign In or Register to comment.