Backing Up Alarm and Event Data

About this task

If you are upgrading to the newest version of Historian and you have already collected alarms, you can migrate the Historical Alarm and Event data after upgrading to latest version of Historian. Alarms are not available for retrieval until they are migrated. New alarms collected with the new version of Historian will be available immediately.

Note: Before migrating alarm and event data, ensure that you have backed up the data.

To migrate your alarms into the new alarm database, you must do a backup of the old alarms and restore them into the new database. The backup can be done before upgrade using the Historian Administrator or it can be done after upgrade using the Proficy Alarm Database Migration Tool on the start menu.

To back up the alarm and event data:

Procedure

  1. Click the Backup Existing Alarms and Events tab.
  2. In the Time Range section, in the From and To fields, set the start time and end time. You may need to migrate small time periods if you have many alarms. If you need to migrate the alarms in blocks of time, do the oldest alarms first.
  3. In the Database Name field, enter the name of the database from which you have to backup the data. Typically, this will be the same as the SQL Server you are currently using.
  4. Select either windows or SQL server authentication by selecting the Use Windows Authentication or Use SQL Authentication options.
  5. In the User Id and Password fields, enter the login credentials. Be sure to use a user name with permission to connect and backup alarms.
  6. In Backup Folder Path field, give the absolute path, including file name, to store the backed up alarms. For example, c:\temp\March2010.bak. Provide the path to place the backup folder on the local computer and if your SQL server is running on a remote computer, enter a path that exists on the remote computer.
  7. Click the Test Connection button to check that the source database is active and the information is accurate. The Begin Backup button is activated.
  8. Click the Begin Backup button to backup the alarms and when the backup is complete, you will get a count of rows backed up.