Upgrade an Existing ACM

Use the following steps to upgrade an existing ACM in place.

Regarding SQL Replication:

If you are using SQL redundancy and you are replicating all objects, you only need to update the primary database and SQL replication will take care of updating all redundant servers.

If you are only replicating a few objects you will need to

Disable replication,
Update the primary database following all the steps below
Re-do Step 4 for each subscriber database.
After all databases have been updated, then you may reenable replication.

SQLUpdate_37 modifies the primary key of tblItems. If you are replicating this table and upgrading from DB version 36 or lower to DB Version 37 or higher, you will need to remove it as an article of replication, perform the update and then add it back. Instructions are here: Remove and Add a Table as an Article of Replication

Step 1: Stop all ACM Services:

Before running the new ACM installer you must:

Disconnect all HMI’s and OPC Clients from ACM to prevent asiData from being restarted
Stop all ACM services in the ACM Monitor on the Status tab.
Exit ACM Monitor from the Task Tray by right clicking the ACM Monitor icon and selecting “Exit”.

Step 2: Back up the ACM SQL database:

This step is not required, but is highly encouraged - especially if you are not already performing nightly backups.

Depending on the size of your database, this step may take a while to complete. To back up your database:

Open SSMS
Right-click the ACM database you plan to upgrade
Select “Tasks-> Back Up”

Unless the destination file you wish to back up to is already listed, “Remove” any you don’t wish to use, and click “Add” to add the new one.

Step 3: Upgrade ACM

Follow steps 1-13 detailed on the Installation guide.

If you allowed the installer to update the database, and you are not replicating OR you did not have to turn off replication, you are done! Otherwise continue to Step 4 to upgrade the database.

Step 4: Upgrade the ACM Database

If you elected not to upgrade the database via the installer or if you are using replication and had to disable it, perform the following on each subscriber/redundant database.

In the ACM Monitor database wizard, confirm the correct Server and Database name are entered and click the “Create/Update Database” button.

The database wizard will open using the connection settings you just entered. If this user has adequate database server permissions, click “Next”, otherwise change the user to one with permission to modify the database and then click “Next”.
Select Update existing database and click “Next”
- The following form loads with the already saved values - the same as are seen in the $Server object. Change them if you wish to and then click “Next”.
- Click “Finish” to upgrade the database.
- When it reports success, click “Done”.

Step 5: Reconfigure SQL Replication

If you had to turn off replication or remove any articles of replication, you can reconfigure it now.