Comparison options can be specified under the xml element <DataCompareOptions>.

The following xml fragment specifies two additional comparison options: GenerateDetailedLog and LogScriptExecution

<?xml version="1.0" encoding="utf-8" ?>
<SqlDataCompareCmdConfig xmlns="http://www.xsqlsoftware.com/schemas/xSQLDataCompareCmdSchema.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>

For the full list of supported options, check Xml Reference.

 

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