Page History

The command line wizard organizes the comparison options into three groups:

• Comparison Options: . contains the options that effect the comparison of the SQL Server databases.
• Scripting Options: . contains the options that are used to generate the synchronization script.
• Execution Options: . contains the options that effect the execution of the synchronization script.

...

The following is an example of the xml fragment generated when some comparison options have been changed:

<SelectedComparisonOptions>
  <ComparisonOption>IgnoreNameInDefinition</ComparisonOption>
  <ComparisonOption>IgnoreViewComments</ComparisonOption>
  <ComparisonOption>IgnoreProcedureComments</ComparisonOption>
  <ComparisonOption>IgnoreFunctionComments</ComparisonOption>
  <ComparisonOption>ScriptSequenceStartValue</ComparisonOption>
  <ComparisonOption>ScriptSequenceMinValue</ComparisonOption>
  <ComparisonOption>ScriptSequenceMaxValue</ComparisonOption>
  <ComparisonOption>LogScriptExecution</ComparisonOption>
</SelectedComparisonOptions>
<ExcludedComparisonOptions>
  <ComparisonOption>CompareDataCompression</ComparisonOption>
  <ComparisonOption>CompareTableChangeTracking</ComparisonOption>
  <ComparisonOption>CompareTableChangeDataCapture</ComparisonOption>
  <ComparisonOption>CompareTableLockEscalation</ComparisonOption>
  <ComparisonOption>ScriptAnsiNullsSetting</ComparisonOption>
  <ComparisonOption>ScriptQuotedIdentifierSetting</ComparisonOption>
  <ComparisonOption>ScriptAnsiPaddingSetting</ComparisonOption>
</ExcludedComparisonOptions>