Workflow for Migrating Alarms and Events Data

If the alarms and events data is currently in Microsoft SQL 2008 or later:
  1. Install the following components on the target machine in the given sequence:
    1. Historian
    2. Alarms and Events
    3. Collectors
    4. Client Tools
    5. Standalone Help
  2. Back up the alarms and events data.
  3. Install Microsoft SQL on the target machine. Refer to Software Requirements for a list of supported versions.
  4. Restore the data that you have backed up to Microsoft SQL 2016.
If the alarms and events data is currently in a version earlier than Microsoft SQL 2008:
  1. Using Microsoft SQL Server Management Studio, back up the alarms and events data. If the database is large, consider taking a partial backup instead of a full backup.
  2. Install Microsoft SQL Server 2008 on the target machine.
  3. Restore the data that you have backed up in step 1.
  4. In Microsoft SQL Server Management Studio, under Databases, right-click the database that you have restored, and then select Properties > Options.
  5. In the Compatibility level field, select SQL Server 2008.
  6. Install the following components on the target machine in the given sequence:
    1. Historian
    2. Alarms and Events
    3. Collectors
    4. Client Tools
    5. Standalone Help
  7. Back up the alarms and events data that you have restored in step 3.
  8. Install a supported version of Microsoft SQL on the target machine. Refer to Software Requirements for a list of supported versions.
  9. Restore the data that you have backed up in step 7 to Microsoft SQL.