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.
Comments
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.