Select rows to synchronize in command line

stepulya

Is it possible to select rows to be synchronized by SQL Data Compare using command line?
I want to programmatically do the same as described here:
https://documentation.red-gate.com/sdc13/deploying-the-data-sources/setting-up-the-deployment

I didn`t find an answer in documentation
https://documentation.red-gate.com/sdc13/using-the-command-line/command-line-syntax/switches-used-in-the-command-line

Thanks.

steven Evans

I am looking for a similar solution.  i have a table which contains static application data which the users can add to.  A flag on each row is used to distinguish between the static and user data. 

I want to track changes to the static data but not the user data from SQL Source Control.

sam.blackburn

Your best bet is probably to save a WHERE clause into the project file.  This will cause SQL Data Compare to ignore rows that don't match your predicate.