Can we set actions from command prompt...

murthy

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 ..
Satya,

peter.peart

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
/Exclude:table:WidgetReferences

And for certain columns:

sqldatacompare /db1:WidgetStaging /db2:WidgetProduction
/ExcludeColumns:WidgetReferences:WidgetName

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,

Pete