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

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 <ROOT> 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 <ROOT>\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 <ROOT>\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 <ROOT>\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:

  1. Updating Auditbase using new installation package, with paramerters for update and additionally KEEP_OLD=1
  2. Removing Auditbase by passing /x instead of /i, with KEEP_OLD=1 to preserve settings
  3. 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 <ROOT>\Auditbase 

rem prepare connectivity:

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

cd <ROOT>\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 <ROOT>\Auditbase 

rem prepare connectivity:

msiexec /i GuptaConnectivity.msi /qb SERVER_TYPE=SB HOST=<ServerIP> 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 <ROOT>\Auditbase 

rem prepare connectivity:

msiexec /i GuptaConnectivity.msi /qb SERVER_TYPE=SB HOST=<ServerIP> 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



    • Related Articles

    • How do I install 64 Bit drivers?

      64 Bit drivers 64-bit drivers (ODBC and OLE DB) let 64-bit applications (like MS Office 64-bit) access SqlBase databases. Installation is intended for use in 64-bit environment where AuditBase is already installed and configured. To install drivers - ...
    • How do I download and install Crystal Reports in Auditbase?

      +44 (0) 333 444 4212 www.auditdata.com support@auditdata.com Generic guide for downloading and installing Crystal Reports in Auditbase. Installing and saving the new reports to Auditbase To install your new Crystal reports the first task is to make a ...
    • What's new in Auditbase

      Auditbase 6.6.0 Auditbase 6.5.0 Auditbase 6.4.0 Auditbase 6.3.0 Auditbase 6.2.0 Auditbase 6.1.0 Auditbase 6.0.3 Auditbase 6.0.2 Auditbase 6.0.1 Auditbase 6.0.0 Auditbase 5.4.6 Auditbase 5.4.5 Auditbase 5.4.4 Auditbase 5.4.3 Auditbase 5.4.2 Auditbase ...
    • How do I set up Auditbase for Waiting List Prioritisation?

      +44 (0) 333 444 4212 www.auditdata.com support@auditdata.com Setting up Auditbase for Waiting List Prioritisation. The clinical validation of diagnostic waiting lists project[1] will produce a clinically validated waiting list that allows diagnostic ...
    • How do I set Auditbase to support 5 minute appointments?

      System Administration Booking and Timetable: There have been changes made to the Booking and Timetable portion of AuditBase. This has improved the reliability of the system when there are multiple users on the system. The previous restriction of 250 ...