xSQL Comparison Bundle for Oracle Databases - v9
Schema comparison options

The command line wizard organizes comparison options into four steps:

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

  <SelectedCompareOptions>
    <!-- ***** the following comparison options will be set TRUE ***** -->
    <ComparisonOption>CompareSynonymBaseObjectSchema</ComparisonOption>
    <ComparisonOption>CompareSynonymDatabaseLink</ComparisonOption>
    <ComparisonOption>ScriptColumnIdentitySequenceOptions</ComparisonOption>
  </SelectedCompareOptions>
  <ExcludedCompareOptions>
    <!-- ***** the following comparison options will be set FALSE ***** -->
    <ComparisonOption>IgnorePrimaryKeyName</ComparisonOption>
    <ComparisonOption>IgnoreUniqueConstraintName</ComparisonOption>
    <ComparisonOption>CompareLobSegment</ComparisonOption>
    <ComparisonOption>CompareLobStorageInRow</ComparisonOption>
    <ComparisonOption>ScriptLogging</ComparisonOption>
    <ComparisonOption>ScriptTableObjectIdentifierType</ComparisonOption>
    <ComparisonOption>ScriptNestedTable</ComparisonOption>
    <ComparisonOption>ScriptNestedTableDependants</ComparisonOption>
  </ExcludedCompareOptions>


 

 


Copyright © 2019 xSQL Software - All rights reserved.

Send us your comments