Select rows to synchronize in command line

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.
Tagged:

Answers

  • steven Evanssteven Evans Posts: 10 Bronze 2
    edited February 20, 2019 11:30AM
    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.
  • 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.
    Software Developer
    Redgate Software
Sign In or Register to comment.