<SqlDataCompareCmdConfig>
     <LeftDatabase>
          <SqlServer>string</SqlServer>
          <DatabaseName>string</DatabaseName>
          <Username>string</Username>
          <Password>string</Password>
          <TrustedConnection>boolean</TrustedConnection>
          <ConnectionTimeout>int</ConnectionTimeout>
          <CommandTimeout>int</CommandTimeout>
     </LeftDatabase>
     <RightDatabase>
          <SqlServer>string</SqlServer>
          <DatabaseName>string</DatabaseName>
          <Username>string</Username>
          <Password>string</Password>
          <TrustedConnection>boolean</TrustedConnection>
          <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>
     <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>

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

ElementDescription

SqlDataCompareCmdConfig

Root element.

LeftDatabase, RightDatabase 

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

SqlServer

Defines the name of the SQL Server instance.
DatabaseNameDefines the database name.

Username, Password

Define database credentials.

TrustedConnection

Defines the connection type.

ConnectionTimeout

Defines the connection timeout in seconds, which the amount of time that command line waits before aborting a connection.

CommandTimeout

Defines the execution timeout of SQL queries in seconds, which the amount of time that 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 memory tables supported by SQL 2014 should be compared and synchronized.

CompareColumnStoreTables

Indicates whether the columnstore tables supported by SQL 2014 should be compared and synchronized.

CompareViews

Indicates whether database views should be compared and synchronized.

DisableTriggers

Specifies the type of action on DML triggers that should be performed by 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.
LogScriptExecutionSpecifies whether the command line should save to a log file SQL statements executed during data synchronization.

ScriptExecutionLogFile

Defines the file name of the execution log.

GenerateTransactionalScript

Indicates whether the generated synchronization script should be transactional.
IgnoreCharCaseIndicates 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.

RoundApproximateNumber

Indicates whether approximate SQL Server types such as float and real should 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 compare.

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 database is synchronized with the right database or vice versa.

Synchronize

Indicates whether the command line should synchronize databases. By default databases are only compared.

TableMappingSchema

Defines the mapping type of database 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 to Custom.
ViewPairsDefines that pair of views that should be mapped manually. Manual pairs require the option TableMappingSchema to be set to Custom.

 

 

Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > >
  • No labels