Page tree

<DataCompareCmdConfig>
  <LeftDatabase>
    <ConnectionName>string</ConnectionName>
    <OracleAuthentication>boolen</OracleAuthentication>
    <Username>string</Username>
    <Password>string</Password>
    <DatabaseSchema>string</DatabaseSchema>
    <ConnectionType>ConnectionTypes</ConnectionType>
    <Host>string</Host>
    <Port>int</Port>
    <Service>string</Service>
    <DataSource>string</DataSource>
    <DbaPrivilege>DbaPrivileges</DbaPrivilege>
    <ConnectionTimeout>int</ConnectionTimeout>
    <CommandTimeout>int</CommandTimeout>
  </LeftDatabase>
  <RightDatabase>
    <ConnectionName>string</ConnectionName>
    <OracleAuthentication>boolean</OracleAuthentication>
    <Username>string</Username>
    <Password>string</Password>
    <DatabaseSchema>string</DatabaseSchema>
    <ConnectionType>ConnectionTypes</ConnectionType>
    <Host>string</Host>
    <Port>int</Port>
    <Service>string</Service>
    <DataSource>string</DataSource>
    <DbaPrivilege>DbaPrivileges</DbaPrivilege>
    <ConnectionTimeout>int</ConnectionTimeout>
    <CommandTimeout>int</CommandTimeout>
  </RightDatabase>


  <DataCompareOptions>
    <CompareTables>boolean</CompareTables>
    <CompareViews>boolean</CompareViews>
    <DisableTriggers>boolean</DisableTriggers>
    <ForeignKeyAction>ForeignKeyActions</ForeignKeyAction>
    <GenerateDetailedLog>boolean</GenerateDetailedLog>
    <LogScriptExecution>boolean</LogScriptExecution>
    <ScriptExecutionLogFile>string</ScriptExecutionLogFile>
    <GenerateTransactionalScript>boolean</GenerateTransactionalScript>
    <IgnoreCharCase>boolean</IgnoreCharCase>
    <TrimSpaces>boolean</TrimSpaces>
    <PerformDependencyAnalysis>boolean</PerformDependencyAnalysis>
    <ReportEqualRows>boolean</ReportEqualRows>
    <SynchronizeDifferentRows>boolean</SynchronizeDifferentRows>
    <SynchronizeLeftRows>boolean</SynchronizeLeftRows>
    <SynchronizeRightRows>boolean</SynchronizeRightRows>
    <TransactionSize>int</TransactionSize>
    <RoundApproximateNumber>boolean</RoundApproximateNumber>
    <RoundPrecision>int</RoundPrecision>
  </DataCompareOptions>

  <CommandLineOptions>
    <ComparisonLogFile>string</ComparisonLogFile>
    <OverwriteComparisonLog>boolean</OverwriteComparisonLog>
    <ErrorLogName>string</ErrorLogName>
    <ErrorLogType>ErrorLogTypes</ErrorLogType>
    <QuietMode>boolean</QuietMode>
    <DataScriptFile>string</DataScriptFile>
    <DataLogFile>string</DataLogFile>
    <FileEncoding>Encodings</FileEncoding>
    <Direction>CompareDirections</Direction>
    <Synchronize>boolean</Synchronize>
    <TableMappingSchema>TableMappingSchemaTypes</TableMappingSchema>
  </CommandLineOptions>

  <TablesMappingRules>
    <NameMapping>NameMappingType</NameMapping>
  </TablesMappingRules>
  <ViewsMappingRules>
    <NameMapping>NameMappingType</NameMapping>
  </ViewsMappingRules>

  <TablePairs>Pairs</TablePairs>
  <ViewPairs>Pairs</ViewPairs>

  <NameMappingType>
    <MappingRule>NameMappingRules</MappingRule>
    <IgnoreLeftName>string</IgnoreLeftName>
    <IgnoreRightName>string</IgnoreRightName>
  </NameMappingType>

  <NameMappingRules>ExactMatch|IgnorePrefix|IgnorePostfix</NameMappingRules>
  <SchemaPairs>[1..*]SchemaPairType</SchemaPairs>
  <SchemaPairType>
    <LeftSchema>string</LeftSchema>
    <RightSchema>string</RightSchema>
  </SchemaPairType>

  <Pairs>[0..*]Pair</Pairs>
  <Pair>
    <LeftObject>TableOrView</LeftObject>
    <RightObject>TableOrView</RightObject>
    <Columns>Columns</Columns>
    <WhereClause>string</WhereClause>
    <Action>Actions</Action>
  </Pair>
  <TableOrView>
    <Key>DataKey</Key>
    <Name>string</Name>
  </TableOrView>
  <DataKey>
    <Name>string</Name>
    <Column>[1..*]string</Column>
  </DataKey>
  <Columns>
    <Action>Actions</Action>
    <ColumnPair>[1..*]ColumnPair</ColumnPair>
  </Columns>
  <Actions>Include|Exclude</Actions>
    <ColumnPair>
    <LeftColumn>string</LeftColumn>
    <RightColumn>string</RightColumn>
  </ColumnPair>

  <ConnectionTypes>Basic|TnsIdentifier|EasyConnect|ConnectDescriptor</ConnectionTypes>
  <DbaPrivileges>Default|SysDba|SysOper</DbaPrivileges>

  <ForeignKeyActions>DisableAndEnable|DropAndCreate|None</ForeignKeyActions>
  <ErrorLogTypes>File|WindowsLog</ErrorLogTypes>
  <Encodings>Unicode|UTF7|UTF8|ASCII|ANSI</Encodings>
  <CompareDirections>LeftAsRight|RightAsLeft</CompareDirections>
  <TableMappingSchemaTypes>Auto|Custom</TableMappingSchemaTypes>

</DataCompareCmdConfig>


The main elements of xml schema are described in the following section:

ElementDescription

DataCompareCmdConfig

Root element.

LeftDatabase, RightDatabase 

The elements that specify the left and the right database that participate in the data comparison.

ConnectionName

Specifies the name of the SQL Server instance.
OracleAuthenticationIf true, the connection uses Oracle authentication.

Username, Password

Define database credentials if the authentication is set to OracleAuthentication.
DatabaseSchemaDefines the schema that should be compared. If not specified, the schema associated with the connection will be used.
ConnectionTypeIndicates the Oracle connection type: Basic, TnsIdentifier, EasyConnect or ConnectDescriptor.
HostDefines the Oracle host name or IP. Host is considered when the connection type is "Basic".
PortDefines the port number. If not specified, the default port 1521 will be used. Port is considered only when the connection type is "Basic".
ServiceDefines the Oracle service name. Service name is considered only when the connection type is "Basic".
DataSourceDefines the connection string for the Oracle database. DataSource is considered only when the connection type is TnsIdentifier, EasyConnect or ConnectDescriptor.
DbaPrivilegeDefines the privileges associated with the connection.
ConnectionTimeoutDefines the connection timeout in seconds, which the amount of time the command line waits before aborting a connection.
CommandTimeoutDefines the execution timeout of Oracle queries in seconds, which the amount of time the command line waits for a query to complete before aborting it.
CompareTablesIndicates whether the Oracle tables should be compared and synchronized.
CompareViewsIndicates whether Oracle views should be compared and synchronized.
DisableTriggersIndicates whether the triggers should be disabled before executing the synchronization script.
ForeignKeyActionSpecifies the type of action on foreign keys that should be performed by synchronization script.
GenerateDetailedLogIndicates whether the command line should generate a detailed synchronization log.
LogScriptExecutionSpecifies whether the command line should save to a log file statements executed during the synchronization.
ScriptExecutionLogFileDefines the file name of the execution log.
GenerateTransactionalScriptIndicates whether the synchronization script should be transactional.
IgnoreCharCaseIndicates whether the character chase should be ignored when comparing string columns.
TrimSpacesIndicates whether the leading and trailing spaces should be ignored when comparing string columns.
PerformDependencyAnalysisSpecifies whether command line should analyze object dependencies (based on foreign key relationship) and order the synchronization script accordingly.
ReportEqualRowsIndicates whether the command line should keep the equal rows in the internal row collections. By default equal rows are discarded.
SynchronizeDifferentRowsIndicates whether the rows that have been found different should be synchronized.
SynchronizeLeftRowsIndicates whether the rows found on the left database should be synchronized.
SynchronizeRightRowsIndicates whether the rows found on the right database should be synchronized.
TransactionSizeDefines the max size of the Oracle transaction.
RoundApproximateNumberIndicates whether approximate should be rounding to a specified precision and then compared.
RoundPrecisionDefines the rounding precision for approximate data types such as real and float.
ComparisonLogFileDefines a file name for data compare operational messages.
OverwriteComparisonLogIndicates whether the command line should overwrite all log files. By default command line appends to log file.
ErrorLogNameDefines a file name for the error log.
ErrorLogTypeIndicates whether errors should be logged to file or Windows event log.
QuietModeIndicates the quiet mode which suppresses messages from being displayed on the console.
DataScriptFileDefines a file name for the data synchronization script.
DataLogFileDefines a file name for the data synchronization log.
FileEncodingDefines the encoding of all output file.
DirectionIndicates the "direction" of synchronization whether the left schema is synchronized with the right schema or vice versa.
SynchronizeIndicates whether the command line should synchronize the data. By default, data is compared, but not synchronized.
TableMappingSchemaDefines the mapping type of schema objects: Auto or Custom.
TablesMappingRulesDefines the mapping rules for tables.
ViewsMappingRulesDefines the mapping rules for views.
NameMappingDefines the mapping rule that applies to objects name.
TablePairsDefines that pair of tables that should be mapped manually. Manual pairs require the option TableMappingSchema to be Custom.
ViewPairs

Defines that pair of views that should be mapped manually. Manual pairs require the option TableMappingSchema to be Custom.

IDERA ProductsPurchase | Support | Community | Resources | About Us | Legal