Hi,
our comparisons we often have to deal with existing data coming from previous usage. So we need the capability to ignore (or exclude) existing records from certain tables in source only if these records are not present in target also.
I see that there's no such "post-comparison" filter like for Schema comparison.
On the other hand I can't define a WHERE condition fitting our needs, because it is related to an "EXISTS" clause which would involve the target DB.
Is there any way we can get through this problem?
Thank you
Data Compare for SQL Server: exclude records from source/target only for certain tables
-
- Posts: 1
- Joined: Mon 11 Mar 2019 13:27
Re: Data Compare for SQL Server: exclude records from source/target only for certain tables
We recommend you to review the Сustom Query feature on this http://docs.devart.com/studio-for-sql-server/comparing-synchronizing-data/mapping-tables-and-views.html