What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    steven Evanssteven Evans Posts: 11 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.
  • Options
    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.