Options

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
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
This discussion has been closed.