Upgrade the Database and the Operating System

About this task

This topic describes how to upgrade the following components of Proficy MDC while upgrading Plant Applications:

Operating system: Windows version 2012 to version 2016
Database: Microsoft SQL sever version 2012 to version 2016

Procedure

Backup the SOADB database by performing the following steps:
1. Delete the replication publication defined for the SOADB database.
2. Set the SOADB database recovery model to simple.
3. Perform a full backup of the SOADB database.
Migrate the database to Windows 2016 and Microsoft SQL server 2016 by performing the following steps:
1. Shut down the Windows 2012 server.
2. Change the host name and IP address of the Windows 2016 server to the host name and IP address of the Windows 2012 server, respectively.
3. Install Microsoft SQL server 2016.
4. Install SQL Server Management Studio (SSMS) and turn on replication. For instructions on turning on the replication, refer to steps 1 through 5 in the Set Up Plant Applications SQL Server for Replication topic.
5. Restore the SOADB database on Windows 2016 and Microsoft SQL server 2016 with the SQL server set to full recovery model.
Link the Proficy MDC components to work with the new database and operating system by performing the following steps:
1. Perform a full backup of the SOADB database.
2. Ensure that SQL Server Agent is enabled.
3. Create a transaction log backup job, and enable the job.
4. Configure Windows 2016 server distribution and publishing. For instructions, refer to steps 6 and 7 in the Set Up Plant Applications SQL Server for Replication topic.
  
  Note:
  Since we are migrating the database server, the T log is truncated.
5. Modify the AWS DMS task and use the following details:
  - Custom CDC start point for source transactions.
  - Select Specify a custom start time (UTC).
  - Specify the start time of the upgrade completion in UTC.
6. Once the task is modified, restart the task.