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>


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels