Comparing views in the same database

crickardcrickard Posts: 2
edited March 9, 2006 3:58PM in SQL Data Compare Previous Versions
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?
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    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.
    · Share on Twitter
  • Tom HarrisTom Harris Posts: 318
    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
    · Share on Twitter
Sign In or Register to comment.