Page History
<DataCompareCmdConfig><SqlDataCompareCmdConfig>
<LeftDatabase>
<SqlServer>string</SqlServer>
<DatabaseName>string</DatabaseName>
<ConnectionName>string</ConnectionName>
<OracleAuthentication>boolen</OracleAuthentication>
<Username>string</Username>
<Password>string</Password>
<TrustedConnection>boolean</TrustedConnection>
<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>
<SqlServer>string</SqlServer>
<DatabaseName>string</DatabaseName>
<ConnectionName>string</ConnectionName>
<OracleAuthentication>boolean</OracleAuthentication>
<Username>string</Username>
<Password>string</Password>
<TrustedConnection>boolean</TrustedConnection>
<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>
<CompareMemoryTables>boolean</CompareMemoryTables>
<CompareColumnStoreTables>boolean</CompareColumnStoreTables>
<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>
<BatchSize>int</BatchSize>
<IgnoreDatabaseCollation>boolean</IgnoreDatabaseCollation>
<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>
<SchemaMapping>SchemaMappingType</SchemaMapping>
<TypeMapping>TypeMappingType</TypeMapping>
</TablesMappingRules>
<ViewsMappingRules>
<NameMapping>NameMappingType</NameMapping>
<SchemaMapping>SchemaMappingType</SchemaMapping>
<TypeMapping>TypeMappingType</TypeMapping>
</ViewsMappingRules>
<TablePairs>Pairs</TablePairs>
<ViewPairs>Pairs</ViewPairs>
<NameMappingType>
<MappingRule>NameMappingRules</MappingRule>
<IgnoreLeftName>string</IgnoreLeftName>
<IgnoreRightName>string</IgnoreRightName>
</NameMappingType>
<SchemaMappingType>
<MappingRule>SchemaMappingRules</MappingRule>
<SchemaPairs>SchemaPairs</SchemaPairs>
</SchemaMappingType>
<TypeMappingType>
<MappingRule>TypeMappingRules</MappingRule>
</TypeMappingType>
<NameMappingRules>ExactMatch|IgnorePrefix|IgnorePostfix</NameMappingRules>
<SchemaMappingRules>ExactMatch|IgnoreSchema|Custom</SchemaMappingRules>
<SchemaPairs>[1..*]SchemaPairType</SchemaPairs>
<SchemaPairType>
<LeftSchema>string</LeftSchema>
<RightSchema>string</RightSchema>
</SchemaPairType>
<TypeMappingRules>ByDefinition|ByCompatibilityMatrix</TypeMappingRules>
<Pairs>[0..*]Pair</Pairs>
<Pair>
<LeftObject>TableOrView</LeftObject>
<RightObject>TableOrView</RightObject>
<Columns>Columns</Columns>
<WhereClause>string</WhereClause>
<LeftWhereClause>string</LeftWhereClause>
<RightWhereClause>string</RightWhereClause>
<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>
</SqlDataCompareCmdConfig>DataCompareCmdConfig>
The main elements of xml schema are described in the following section:
Element | Description | ||||
---|---|---|---|---|---|
SqlDataCompareCmdConfigDataCompareCmdConfig | Root element. | ||||
LeftDatabase, RightDatabase | The elements that specify the left and the right database that participate in the data comparison. | ||||
SqlServerConnectionName | Defines Specifies the name of the SQL Server instance. | ||||
DatabaseNameOracleAuthentication | Defines the database nameIf true, the connection uses Oracle authentication. | ||||
Username, Password | Define database credentials . | ||||
TrustedConnection | Defines the connection type. | ||||
if the authentication is set to OracleAuthentication. | |||||
DatabaseSchema | Defines the schema that should be compared. If not specified, the schema associated with the connection will be used. | ||||
ConnectionType | Indicates the Oracle connection type: Basic, TnsIdentifier, EasyConnect or ConnectDescriptor. | ||||
Host | Defines the Oracle host name or IP. Host is considered when the connection type is "Basic". | ||||
Port | Defines the port number. If not specified, the default port 1521 will be used. Port is considered only when the connection type is "Basic". | ||||
Service | Defines the Oracle service name. Service name is considered only when the connection type is "Basic". | ||||
DataSource | Defines the connection string for the Oracle database. DataSource is considered only when the connection type is TnsIdentifier, EasyConnect or ConnectDescriptor. | ||||
DbaPrivilege | Defines the privileges associated with the connection. | ||||
ConnectionTimeout | Defines the connection timeout in seconds, which the amount of time | thatthe command line waits before aborting a connection. | |||
CommandTimeout | Defines the execution timeout of | SQLOracle queries in seconds, which the amount of time | thatthe command line waits for a query to complete before aborting it. | ||
CompareTables | Indicates whether database tables should be compared and synchronized.CompareMemoryTables | Indicates whether the | memoryOracle tables | supported by SQL 2014should be compared and synchronized. | |
CompareColumnStoreTables | Indicates whether the columnstore tables supported by SQL 2014 should be compared and synchronized. | ||||
CompareViews | Indicates whether | databaseOracle views should be compared and synchronized. | |||
DisableTriggers | Specifies the type of action on DML triggers that should be performed byIndicates whether the triggers should be disabled before executing the synchronization script. | ||||
ForeignKeyAction | Specifies the type of action on foreign keys that should be performed by synchronization script. | ||||
GenerateDetailedLog | Indicates whether the command line should generate a detailed synchronization log. | ||||
LogScriptExecution | Specifies whether the command line should save to a log file | SQLstatements executed during | datathe synchronization. | ||
ScriptExecutionLogFile | Defines the file name of the execution log. | ||||
GenerateTransactionalScript | Indicates whether the | generatedsynchronization script should be transactional. | |||
IgnoreCharCase | Indicates whether the character chase should be ignored when comparing string columns. | ||||
TrimSpaces | Indicates whether the leading and trailing spaces should be ignored when comparing string columns. | ||||
PerformDependencyAnalysis | Specifies whether command line should analyze object dependencies (based on foreign key relationship | between them) and order the synchronization script accordingly. | |||
ReportEqualRows | Indicates whether the command line should keep the equal rows in the internal row collections. By default equal rows are discarded. | ||||
SynchronizeDifferentRows | Indicates whether the rows that have been found different should be synchronized. | ||||
SynchronizeLeftRows | Indicates whether the rows found on the left database should be synchronized. | ||||
SynchronizeRightRows | Indicates whether the rows found on the right database should be synchronized. | ||||
TransactionSize | Defines the max size of | SQL Server transaction that should be used when executing synchronization script.||||
BatchSize | Defines the max batch size that should be used when executing synchronization script. | ||||
IgnoreDatabaseCollation | Indicates whether collation should be ignored when comparing databases. | ||||
the Oracle transaction. | |||||
RoundApproximateNumber | Indicates whether approximate | SQL Server types such as float and realshould be rounding to a specified precision and then compared. | |||
RoundPrecision | Defines the rounding precision for approximate data types such as real and float. | Rounding effects only the comparison of approximate types, not the scripting of these types.||||
ComparisonLogFile | Defines a file name for data compare operational messages. | ||||
OverwriteComparisonLog | Indicates whether the command line should overwrite all log files. By default command line appends to log file. | ||||
ErrorLogName | Defines a file name for | errors that might occur during data comparethe error log. | |||
ErrorLogType | Indicates whether errors should be logged to file or Windows event log. | ||||
QuietMode | Indicates the quiet mode which suppresses messages from being displayed on the console. | ||||
DataScriptFile | Defines a file name for the data synchronization script. | ||||
DataLogFile | Defines a file name for the data synchronization log. | ||||
FileEncoding | Defines the encoding of all output file. | ||||
Direction | Indicates the "direction" of synchronization whether the left | databaseschema is synchronized with the right | databaseschema or vice versa. | ||
Synchronize | Indicates whether the command line should synchronize | databasesthe data. By default | databases are only compared, data is compared, but not synchronized. | ||
TableMappingSchema | Defines the mapping type of | databaseschema objects | whether is: Auto or Custom. | ||
TablesMappingRules | Defines the mapping rules for tables. | ||||
ViewsMappingRules | Defines the mapping rules for views. | ||||
NameMapping | Defines the mapping rule that applies to objects name | .||||
SchemaMapping | Defines the mapping rule that applies to objects schema (owner). | ||||
TypeMapping | Defines the mapping rule that applies to data types. | ||||
TablePairs | Defines that pair of tables that should be mapped manually. Manual pairs require the option TableMappingSchema to be | set toCustom. | |||
ViewPairs | Defines that pair of views that should be mapped manually. Manual pairs require the option TableMappingSchema to be | set to Custom. |
Excerpt |
---|
Total compare from data to schema with IDERA Comparison Toolset. Learn more > > |
...
...