Options
Can we set actions from command prompt...
murthy
Posts: 8
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,
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,
Comments
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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569