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>