Data Compare for SQL Server: exclude records from source/target only for certain tables
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?