Console • Usage

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

FullConvertConsole.exe projectfile OPTIONS

Options:

-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.

-LS <filename>

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

-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.

-LJSON <filename>

Log detailed JSON conversion information, containing performance statistics, errors and other info.

-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.