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.