How can we help you today? How can we help you today?

Can we set actions from command prompt...

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,
murthy
0

Comments

1 comment

Sort by
  • 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
    peter.peart
    0

Add comment

Please sign in to leave a comment.