Command line switches

The command line supports two categories of options.

  • Options that are specified as command line switches. Most of the command line switches have a short and a long name and separate the name from the value by a semicolon.
  • Options that are specified via an xml configuration file. We strongly recommend that you set all command line options via the xml configuration file.

When the option can be specified via the command line and xml file, the command line switch takes precedence.

IDERA SQL Data Compare command line supports the following command line switches:

OptionDescription
xmlfilePerforms a data comparison using settings in the specified xmlfile.
/datascript:filenameSpecifies a file name for the data synchronization script. We recommend you set this option in the xml configuration file.
/datalog:filenameSpecifies a file name for the data synchronization log. We recommend you set this option in the xml configuration file.
/en, /encoding:
(UTF7 | UTF8 | UNICODE | ASCII)
Indicates the encoding that should be used for output files. ANSI encoding is used if no encoding is specified.
/t, /logtype:(windowslog)Indicates the type of error log. You can specify windowslog to log the errors in Windows Event log.
/e, /error:errorlogSpecifies the error log. Depending on the /t option, it could indicate a file or a Windows Event log.
/l, /logfile:filenameSpecifies a file for the data compare operational log. We recommend you specify the option in the xml configuration file.
/o, /overwriteIndicates whether the log files should be overwritten. By default command line appends to output logs.
/q, /quietSpecifies the "quiet" mode of operation, which suppresses all messages from being displayed on the console.
/d, /direction:
(leftasright | rightasleft)
Indicates whether the command line should make the right database the same as the left database or vice versa. You can specify leftasright or rightasleft. We recommend you set this option in the xml configuration file.
/s, /syncIndicates whether the command line should synchronize databases. By default data is only compared but the synchronization script is NOT executed. Use this option carefully since it makes permanent changes in the target database.
/mappingtype:
(auto | custom)
Indicates the mapping of database tables and views. If auto is specified, objects are mapped based on the default mapping: schema.name. If custom is selected, the pairs of objects must be specified manually. The default mapping type is auto. We recommend you set this option in the xml file.
/v, /validateValidates the xml configuration file.
/?, /h, /helpDisplays the command line options.

 

 

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