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.

...

...