Sub Set Compare

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

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


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

    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.