Data Compare for SQL Server: exclude records from source/target only for certain tables

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
mmontelatici
Posts: 3
Joined: Mon 11 Mar 2019 13:27

Data Compare for SQL Server: exclude records from source/target only for certain tables

Post by mmontelatici » Fri 29 Nov 2019 15:25

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


Post Reply