Command line interface

A command line interface is available but generally will only be used by the Infor cloud team. When the command is run, these actions occur:

  • Validate the database. If successful, return the success code and end.
  • If unsuccessful and no remediation options are specified, return the failure code and end.
  • If unsuccessful and remediation options are specified, run the specified remediation options. Then rerun the validation and return the success or failure code.

This is the command syntax:

SVI_Root_Folder\Validator\DBValidatorCmd.exe validate –s”SQL_server_name” 
–d”database_name” –u“user_name” –p”password” [-v] [-c”c:\folder”] 
[-b”c:\folder\tenant_db.bak”] [--fix] [--rename] [--drop]

The first four parameters (server name, database name, user and password) are used to connect to the database that you are validating. The optional parameters have these settings:

  • -c specifies the folder where the validation tool will save log files. If not specified, the log files are saved in SVI_Root_Folder\Validator\ValidationLog.
  • -v specifies verbose mode, which outputs the validation log messages to the command line during validation, as well as to the log file.
  • -b optionally specifies a tenant backup database to import, validate and export. In this case, the backup database is exported to the location specified in the -c option.
  • --fix performs the tasks under ‘Fix option” as described in “Remediation tasks” above.
  • --rename performs the tasks under “Rename option” as described in “Remediation tasks.” This option is ignored if it is specified for a DL0 database.
  • --drop performs the tasks under “Drop option” as described in “Remediation tasks.”