Usage

Console application is invoked by specifying path to the saved project file. Optional parameters can be used to achieve customizations and logging.

ReplicatorConsole.exe projectfile OPTIONS

Options:

-S Synchronizes databases, applies sync script to target

Without this switch, Replicator console will only compare the databases - useful for logging of changes.

-STRATEGY <Overwrite/Folder/Timestamp>

Log saving strategy, default is Overwrite.

  • Overwrite - log is created or rewritten on each run exactly at the filename specified
  • Folder - in the folder of the filename, new folder with a timestamp name is created, inside of which log is created with the name specified (log filename folder\timestamp\log filename)
  • Timestamp - in the folder of the filename, log is created with timestamp prepended to the file name  (log filename folder\timestamp-log filename)

Strategy is global and base folder can be specified for each file or omitted. If omitted, current directory is user as a base folder.

-TABLES <semicolon-delimited list of table names>

List of tables selected for conversion, separated by semicolons. If you want to select all tables in source database, specify * character.

-L <filename>

Write a summary log file, containing basic information about the conversion.

-LD <filename>

Write differences encountered in comparison in the JSON format

-LS <filename>

Write sync script file. If -S switch is not present, this will show statements needed to replicate the data manually.

-LE <filename>

Log conversion errors.

-LSQL <filename>

Log all SQL statements, exactly as they are sent to the target database server to populate the database during conversion.

-LSQLE <filename>

Log SQL statements sent to the target database server, but just ones resulting with an error.

-OSC <parameter=value>

Override connection parameter for source database. Exact parameters depend on the database in question. If you want to specify several parameters, separate each param=value pair with a semicolon.

-OTC <parameter=value>

Override connection parameter for target database. Exact parameters depend on the database in question. If you want to specify several parameters, separate each param=value pair with a semicolon.

-OSM <source=target>

Override schema mapping. It works exactly the same as mapping in GUI version's Mapping . Separate multiple mappings with a semicolon.

-SAVEPROJECT newprojectfile

Save project with all overrides included as a new project and immediately exit.