Navigate to PMTSecurity.com and download the software and save for use at a later step.

OMNIA.exe will Install OMNIA 4.6.5 ONLY

OMNIA.iso  will Install OMNIA 4.6.5 and SQL2019 Express

Backup the OMNIA database.

This step is highly recommended. Keep in mind, regular backups should be conducted. A backup kept off the localhost ensures recovery if OMNIA server becomes unrepairable.

See Knowledgebase Article for Backing Up OMNIA Database

https://pmtronics.com/omnia-database-backup

Ensure the current version of OMNIA Server App and/or OMNIA Service is not running.

OMNIA Server App

Exit out of the OMNIA Server App.
Right Click the OMNIA Server App Icon in the “Show Hidden Icons” from the taskbar and select EXIT

If OMNIA is running as a Service, Open Services and Stop the Service.

Detach the Database from SQL using the Sql Server Management Studio (SSMS)

Open SQL Server Management Studio (SSMS)

Connect Using  “Windows Authentication”

Expand the Database tree, Select OMNIA and Right Click, Select Tasks then Select Detach.

Select Drop and then Select OK

     Navigate to C:\OMNIA\Database\

     Select and Copy BOTH the OMNIA.mdf and OMNIA_log.ldf files. Save files where they can be accessed again. 

Open the Services, Search for SQL Server, Right Click and Select Stop

We recommend this step as a precaution, keeping the previous OMNIA version folder ensures the ability to roll back to the previous version in case of upgrade failure. Renaming the OMNIA folder will provided a clean path of installation for the new software version. The OMNIA installation will create a new OMNIA folder. 

Navigate to C:\OMNIA, highlight the OMNIA folder, right click and select rename.

Name the folder something else. ex.  OMNIA4_5

If the existing site has SQL 2014 configured, the uninstallation of SQL 2014 is required before installing 2019. The OMNIA installation does not upgrade SQL 2014 to SQL 2019 automatically and the SQL 2019 Installation will not occur.

Mount the OMNIA 4.6.5 .ISO 

Right Click OMNIA.exe and run as AdministratorUsing the new OMNIA installer, follow the prompts to complete installation.

Accept the Agreement and Select Next

Select what options you want installed.

In this example we are installing OMNIA, the OMNIA Plugin Mgr,  and SQL 2019 Express with tools. We will be also running the SQL Configuration and Scripts.

Confirm a Database backup has been made, or a copy of the database has been made.

If you receive the message below, you have not completely uninstalled the previous version of 

SQL express completely. Select Yes and Next

Leave this page blank unless the basic OMNIA information has been changed/updated.

Select Next

The below error is common and does not cause concern. SQL has not been installed yet so it cannot connect to the SQL Instance, Select Yes, then Next

This is a false indicator, this installer will not upgrade SQL 2014 to SQL 2019. Select Yes

Select if you would like a short cut for the OMNIA Server App to be placed on the desktop,

Select Install

The installation process may find programs that need to be restarted, Select Automatically close the applications then select Next

The Installation Wizard will complete.

NOTE:

Do not start OMNIA now, You will need to place the OMNIA Database and Log File into the new OMNIA installation database folder before starting OMNIA.

In the C: drive you will see two OMNIA folders.

Navigate to C:\OMNIA\Database and Place the copy of the OMNIA.mdf and OMNIA_log.ldf files there.

Download from Microsoft.com and run the Installer as Administrator

Open the SQL Server Management Studio App

Log into SSMS with “Windows Authentication” with the Encryption set to “Optional”

Highlight Databases, Right Click and Select Attach

In the Attach Database Window

1. Select Add and a Locate Database Files window opens, 
2. in the Locate Database Files window, Use the tree to Navigate to OMNIA, click the (+) to Expand OMNIA
3. Select database
4. Select the OMINA.mdf file
5. Select OK

In the next window, in the Database to Attach field, scroll right to display the “Owner” Column. Use the dropdown to select sysdba as the owner.

1. In the Attach Database window and in the Databases to attach window, Scroll right
2. Find the Owner Column
3. Use the dropdown to select sysdba as the owner
4. In the OMNIA database details, Scroll right to the Current File Path
5. Verify location of database and log file is correct. 
6. Select OK

Navigate to C:\OMNIA\Bin64.

Run OMNIA.exe as Admin

If you get Database connection test failed.

Replace the sysdba password with masterkey and select Test Database Connection 

The End Result will be as below, 

Select Save and Restart.

OMNIA is now Upgraded