Page History
Comparison options can be specified under the xml element <DataCompareOptions>
.
The following xml fragment specifies two additional comparison optionsoption: GenerateDetailedLog
and LogScriptExecution
<?xml version="1.0" encoding="utf-8" ?>
<SqlDataCompareCmdConfig <DataCompareCmdConfig xmlns="http://www.xsqlsoftwareidera.com/oracle/schemas/xSQLDataCompareCmdSchemadatacompare/cmd.xsd">
<LeftDatabase>
<SqlServer>(local)</SqlServer>
<DatabaseName>DB_Test1</DatabaseName>
<TrustedConnection>true</TrustedConnection>
</LeftDatabase>
<RightDatabase>
<SqlServer>(local)</SqlServer>
<DatabaseName>DB_Test2</DatabaseName>
<Username>username</Username>
<Password>password</Password>
</RightDatabase>
<DataCompareOptions>
<GenerateDetailedLog>true</GenerateDetailedLog>
<LogScriptExecution>true</LogScriptExecution>
</DataCompareOptions>
<CommandLineOptions>
<Synchronize>true</Synchronize>
<DataScriptFile>DataScript.sql</DataScriptFile>
<Direction>RightAsLeft</Direction>
<ComparisonLogFile>log.txt</ComparisonLogFile>
</CommandLineOptions>
</SqlDataCompareCmdConfig> <LeftDatabase>
<ConnectionName>Oracle Schema 1</ConnectionName>
<ConnectionType>Basic</ConnectionType>
<Username>HR</Username>
<Password>********</Password>
<Host>host-name-or-ip</Host>
<Service>oracle-service-name</Service>
<DatabaseSchema>HR</DatabaseSchema>
</LeftDatabase>
<RightDatabase>
<ConnectionName>Oracle Schema 2</ConnectionName>
<ConnectionType>Basic</ConnectionType>
<Username>HR_TARGET</Username>
<Password>********</Password>
<Host>host-name-or-ip</Host>
<Service>oracle-service-name</Service>
<DatabaseSchema>HR_TARGET</DatabaseSchema>
</RightDatabase>
<DataCompareOptions>
<GenerateDetailedLog>true</GenerateDetailedLog>
</DataCompareOptions>
<CommandLineOptions>
<Direction>RightAsLeft</Direction>
<Synchronize>true</Synchronize>
<DataScriptFile>SyncScript.sql</DataScriptFile>
<DataLogFile>SyncScript.log</DataLogFile>
<ComparisonLogFile>Operational.txt</ComparisonLogFile>
<ErrorLogName>Error.log</ErrorLogName>
</CommandLineOptions>
</DataCompareCmdConfig>
For the full list of supported options, check Xml Reference.
Excerpt |
---|
Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > > |
...
...