If you are not concerned with bringing over any of the History/EFM from the old server to a new instance when you’re migrating to a new environment, then you don’t need to make a SQL backup. Follow the instructions on “Migrate ACM Configuration to a New Server” instead.
Step 1: “Freeze” the existing ACM server:
There is no feature in ACM to do this, so the responsibility lies on the user to prevent any changes being made to the database during the migration period. To do this you must:
Disconnect all HMI’s and OPC Clients from ACM to prevent asiData from being restarted
Disable all ACM services in the ACM Monitor on the Status tab.
Step 2: Back up the ACM SQL database
If you are not concerned with bringing over any of the History/EFM from the old server to a new instance when you’re migrating to a new environment, then you don’t need to make a SQL backup. Simply generate an Export to a .txt file from within ACM, copy that .txt file to the new server, install ACM as normal then import the .txt file. This will bring over your entire ACM configuration but none of the old History/Real-Time data.
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: Copy the database to the new server
Copy the .bak file you created in Step 2 to the correct location on the new server. The default backup location depends upon the version of SQL installed.
Step 4: Restore the database on the new server
To restore the database on the new server in SSMS, right-click on the databases folder and select “Restore Database”.
Select “Device” and click on the ellipsis next to the device field.
Click “Add”:
Navigate to the location in Step 3.
Select the database that you would like to restore and complete the prompts.
Step 5: Update the ACM Monitor Database Connection
Open ACM Monitor, select “Database” and then click the “Manage Database” button.
On the ACM Database Connection form, update the configuration settings.
If you need to upgrade the database, move to step 6, otherwise click “OK” and move to step 7.
Step 6: Upgrade the ACM Database
If you need to upgrade the ACM database after migrating it to the new server, 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”.
