Build Installer Process

First, create the database structure and metadata SQL files. This can be done manually using MySQL Administrator or through the command line as follows:

Dump all the metadata:

 >mysqldump.exe --no-create-info=TRUE --order-by-primary=FALSE --force=FALSE 
  --no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE 
  --replace=FALSE --insert-ignore=FALSE --extended-insert=FALSE --quote-names=TRUE 
  --hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE 
  --delayed-insert=FALSE --create-options=TRUE --delete-master-logs=FALSE --comments=TRUE 
  --default-character-set=utf8 --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE 
  --lock-tables=TRUE --allow-keywords=FALSE --events=FALSE --host={host} --port=5306 
  --user=root --password={pwd} 
  --result-file=CreateDB-Data.sql 
  "productivity1"  "rules_category" "rules_master" "screens" "system_extract_points" 
  "system_extracts" "system styles"

Note: To dump all the data from a remote server (perhaps for support), remove everything after "productivity1"

Dump the structure:

 >mysqldump.exe --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE 
  --no-data=TRUE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE 
  --replace=FALSE --host=localhost --insert-ignore=FALSE --quote-names=TRUE 
  --hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE 
  --delayed-insert=FALSE --create-options=TRUE --skip-extended-insert=TRUE 
  --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 
  --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE 
  --allow-keywords=FALSE --events=FALSE --routines 
  --result-file=CreateDB-Struct.sql 
  --host={host} --port=5306 --user=root --password={pwd} 
  "productivity1"

In these commands, replace {host} and {pwd} with your Vision Host IP address and root password.

Note: To load either file, you can use the following:

 >mysql.exe --host={host} --port=5306 --user=root --password={pwd} 
  --default-character-set=utf8 --comments <{SQL file}

Take these produced files along with all the latest screens and place then into a clean directory. Use the existing Inno Setup installer file to build the installer.