Competition: What’s your favorite Redgate tool? Enter now.

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:

I didn`t find an answer in documentation



  • 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.