Sub Set Compare

masterbakermasterbaker Posts: 19
edited January 27, 2006 11:39AM in SQL Data Compare Previous Versions
Hi,

Is there an example that shows how to compare sub-set data for two dba? thanks

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    This is something that the current version of Data Compare cannot do. The recommended workaround is to create indexed views on the tables and compare data through them. In the overwhelming majority of databases, you can also synchronize directly through an indexed view. If the database doesn't allow this, you can work around the problem using instead of triggers on the view.
This discussion has been closed.