| Element | Description |
|---|
DataCompareCmdConfig | Root element. |
LeftDatabase, RightDatabase | The elements that specify the left and the right database that participate in the data comparison. |
ConnectionName | Specifies the name of the SQL Server instance. |
| OracleAuthentication | If true, the connection uses Oracle authentication. |
Username, Password | Define database credentials 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 the command line waits before aborting a connection. |
| CommandTimeout | Defines the execution timeout of Oracle queries in seconds, which the amount of time the command line waits for a query to complete before aborting it. |
| CompareTables | Indicates whether the Oracle tables should be compared and synchronized. |
| CompareViews | Indicates whether Oracle views should be compared and synchronized. |
| DisableTriggers | Indicates 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 statements executed during the synchronization. |
| ScriptExecutionLogFile | Defines the file name of the execution log. |
| GenerateTransactionalScript | Indicates whether the synchronization 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) 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 the Oracle transaction. |
| RoundApproximateNumber | Indicates whether approximate should be rounding to a specified precision and then compared. |
| RoundPrecision | Defines the rounding precision for approximate data types such as real and float. |
| 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 the 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 schema is synchronized with the right schema or vice versa. |
| Synchronize | Indicates whether the command line should synchronize the data. By default, data is compared, but not synchronized. |
| TableMappingSchema | Defines the mapping type of schema objects: 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. |
| TablePairs | Defines that pair of tables that should be mapped manually. Manual pairs require the option TableMappingSchema to be Custom. |
| ViewPairs | Defines that pair of views that should be mapped manually. Manual pairs require the option TableMappingSchema to be Custom. |