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
-S Synchronizes databases, applies sync script to target
Without this switch, Replicator console will only compare the databases - useful for logging of changes.
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.
Write a summary log file, containing basic information about the conversion.
Write differences encountered in comparison in the JSON format
Write sync script file. If -S switch is not present, this will show statements needed to replicate the data manually.
Log conversion errors.
Log all SQL statements, exactly as they are sent to the target database server to populate the database during conversion.
Log SQL statements sent to the target database server, but just ones resulting with an error.
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.
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.
Override schema mapping. It works exactly the same as mapping in GUI version's Mapping . Separate multiple mappings with a semicolon.
Save project with all overrides included as a new project and immediately exit.