How do I upgrade and install Auditbase using the Command Line?

UPGRADING AND INSTALLING AUDITBASE USING THE COMMAND LINE

Examples below have some variable parts that should or may be replaced with custom values, they are highlighted with a yellow background.

If highlighted text is italic – then replacing is mandatory.

Grey lines starting with ‘rem’ are comments for explanation only, they need no execution or inclusion in scripts but can remain in batch files.

A folder refers to a root of Auditbase delivery package. Spoiler: most interesting things are in its Auditbase subfolder.

Bootstrapped upgrade from command line

To update an existing Auditbase installation as a whole regardless of its current version and configuration use the following:

cd \Auditbase\autorun

demo32.exe -q -vs1"Admin" SetupNoahAB.dbd

rem reboot may be required after setup to get system functional

Noah will be upgraded only where installed. Laptop SQLBase engines will not be upgraded.

Update or repair of existing Auditbase installation by separate steps

If you want to break apart the full installation and install its’ components separately or exclude some components you may use the following scripts, depending which version you are upgrading from:

Using auditbase.msi in the update mode the parameters REINSTALL=ALL and REINSTALLMODE=vomus are used.

Updating an existing Auditbase 6

cd \Auditbase

msiexec /i GuptaConnectivity.msi /qb ADDLOCAL=ALL

rem Noah 4 prerequisites and engine:

msiexec /i "NOAH\Noah 4.msi" /qb /norestart EULAACCEPTED=YES FORCEINSTALL=1

msiexec /i "NOAH\BasicModules\Noah 4 Audiogram Module.msi" /qb

rem Auditbase prerequisites and components:

msiexec /x {82367C1B-853A-43F1-9D39-CE1AC3E6DE8C} /passive

msiexec /i TDDeployment.msi /passive REINSTALL=ALL REINSTALLMODE=vomus

msiexec /i AuditBaseSetup\auditbase.msi SETUP_TYPE=Admin REINSTALLMODE=vomus REINSTALL=ALL

Updating an existing Auditbase 5

cd \Auditbase

msiexec /i GuptaConnectivity.msi /qb ADDLOCAL=ALL

rem Noah 4 prerequisites and engine:

NOAH\DotNet4\NDP461-KB3102436-x86-x64-AllOS-ENU.exe /passive /norestart

msiexec /i "NOAH\MSSQL_CE\SSCERuntime_x86-ENU.msi" /passive

msiexec /i "NOAH\Noah 4.msi" /qb /norestart EULAACCEPTED=YES FORCEINSTALL=1

msiexec /i "NOAH\BasicModules\Noah 4 Audiogram Module.msi" /qb

rem Auditbase prerequisites:

msiexec /i CRXIRuntime.msi /qb

vcredist_x86.exe /passive

VC2005\vcredist_x86.exe /q

VC2008\vcredist_x86.exe /qb

VC2015\vcredist_x86.exe /passive

msiexec /x {82367C1B-853A-43F1-9D39-CE1AC3E6DE8C} /passive

msiexec /i TDDeployment.msi /qb

rem Auditbase 3-step refresh:

msiexec /i AuditBaseSetup\auditbase.msi /passive KEEP_OLD=1 SETUP_TYPE=Admin REINSTALLMODE=vomus REINSTALL=ALL

msiexec /x AuditBaseSetup\auditbase.msi /passive KEEP_OLD=1

msiexec /i AuditBaseSetup\Auditbase.msi /passive /norestart SETUP_TYPE=Admin

Comment about last three steps regarding folder and old settings:

The update from Auditbase 5 to Auditbase 6 involves a change of installation folder from ‘Auditbase 5’ to ‘Auditbase’. Limitations of MS Installer require this to be done by performing an uninstallation from the old folder followed by installation to a new folder.

A special parameter was introduced to Auditbase 6 for auditbase.msi to preserve existing settings. This preservation was not available in Auditbase 5 therefore it is necessary to do the upgrade to a new version in the old folder first, to be able then to do the folder move without losing the old settings.

This results in a three step sequence:

Updating Auditbase using new installation package, with paramerters for update and additionally KEEP_OLD=1
Removing Auditbase by passing /x instead of /i, with KEEP_OLD=1 to preserve settings
Installing fresh Auditbase in the proper place

Installation of Auditbase on the empty system

A bootstrapped command for a silent installation from scratch – needs a pre-configuration of connectivity, as well as additional options for NOAH and Viewer.

Example of laptop 12.2 setup with NOAH and without Viewer mode:

cd \Auditbase

rem prepare connectivity:

msiexec /i GuptaConnectivity.msi /qb SERVER_TYPE=SB HOST= ENGINE=Server1 DBS=ABASE,DOCUMENT SQLBASE_VERSION=122

cd \Auditbase\autorun

demo32.exe -q -vs1"Admin" -vs2"INSTALL_NOAH" -vs3"VIEWER=0" SetupNoahAB.dbd

rem reboot may be required after setup to get system functional

Install of Auditbase + NOAH

cd \Auditbase

rem prepare connectivity:

msiexec /i GuptaConnectivity.msi /qb SERVER_TYPE=SB HOST= ENGINE=Server1 DBS=ABASE,DOCUMENT

rem Noah 4 prerequisites and engine:

msiexec /i "NOAH\MSSQL_CE\SSCERuntime_x86-ENU.msi" /passive

msiexec /i "NOAH\Noah 4.msi" /qb /norestart EULAACCEPTED=YES FORCEINSTALL=1

msiexec /i "NOAH\BasicModules\Noah 4 Audiogram Module.msi" /qb

rem Auditbase prerequisites and components:

msiexec /i CRXIRuntime.msi /qb

vcredist_x86.exe /passive

VC2005\vcredist_x86.exe /q

VC2008\vcredist_x86.exe /qb

VC2015\vcredist_x86.exe /passive

msiexec /i TDDeployment.msi /qb

msiexec /i AuditBaseSetup\Auditbase.msi /passive /norestart SETUP_TYPE=Admin

rem reboot may be required after setup to get system fully functional

Laptop mode installation

cd \Auditbase

rem prepare connectivity:

msiexec /i GuptaConnectivity.msi /qb SERVER_TYPE=SB HOST= ENGINE=Server1 DBS=ABASE,DOCUMENT SQLBASE_VERSION=122

rem Noah 4 prerequisites and engine:

msiexec /i "NOAH\MSSQL_CE\SSCERuntime_x86-ENU.msi" /passive

msiexec /i "NOAH\Noah 4.msi" /qb /norestart EULAACCEPTED=YES FORCEINSTALL=1

msiexec /i "NOAH\BasicModules\Noah 4 Audiogram Module.msi" /qb

rem Auditbase prerequisites and components:

msiexec /i CRXIRuntime.msi /qb

vcredist_x86.exe /passive

VC2005\vcredist_x86.exe /q

VC2008\vcredist_x86.exe /qb

VC2015\vcredist_x86.exe /passive

msiexec /i SqlBase12.2x32\Sqlbase.msi /passive

msiexec /i TDDeployment.msi /qb

msiexec /i AuditBaseSetup\Auditbase.msi /passive /norestart SETUP_TYPE=Admin

rem reboot may be required after setup to get system fully functional