Can we set actions from command prompt...

murthymurthy Posts: 8
edited September 23, 2009 12:17PM in SQL Data Compare Previous Versions
Hi ,

Sqldata Compare i am running it from command prompt like...

SQLDataCompare.exe /project:c:\testSync.sdc /synchronize

Here default Action is "Include All" so it is just replacing one database to another database.

Can anybody suggest how to use "Taraget Only,Different Only..." Action from Command prompt.

And how can we apply :Target only" Action for some tables and "Source only" Action for some tables.

Thanks ..


  • Options
    Hi Satya,

    A list of command line arguments can be found by following the below link:

    http://www.red-gate.com/supportcenter/C ... 700076.htm

    You can either use the command line to include and exclude certain tables like the below example:

    sqldatacompare /db1:WidgetStaging /db2:WidgetProduction

    And for certain columns:

    sqldatacompare /db1:WidgetStaging /db2:WidgetProduction

    You appear however to be referencing a project file, therefore if before running the comparison you set to exclude certain tables / columns and save that as a project file then you will be able to use all the settings in the project file for the comparison and synch.

    Hope that helps,

    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.