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>IgnoreTriggerComments</ComparisonOption>
</SelectedComparisonOptions>
<ExcludedComparisonOptions>
<ComparisonOption>CompareSystemVersioning</ComparisonOption>
<ComparisonOption>IgnoreSystemVersioningHistoryTableName</ComparisonOption>
<ComparisonOption>CompareRemoteDataArchiving</ComparisonOption>
<ComparisonOption>CompareFullTextStopListWords</ComparisonOption>
</ExcludedComparisonOptions>