Restore the Alarms and Events Data

Install Microsoft SQL. Refer to Software Requirements for a list of supported versions.

Procedure

  1. Go to the <Historian installation folder>\Proficy DataBase folder, and open the Proficy.Historian.AandE.Migration.exe file.
    The Backup Existing Alarms and Events window appears.
  2. Select Migrate Alarms and Events Backup.
  3. In the Backup Folder Path field, provide the absolute path of the file (including the file name) in which you want to restore the data (for example, c:\temp\March2010.bak). You can enter the path of a local file or a remote one, depending on whether the Microsoft SQL server is installed on the local machine or a remote machine.
  4. In the Database Name field, enter the name of the database that you want to back up. Typically, this value is the same as the Microsoft SQL server you are using.
  5. Depending on whether you want to use Windows credentials or Microsoft SQL credentials, select either Use Windows Authentication or Use SQL Authentication, respectively.
  6. In the User Id and Password fields, enter the login credentials. Provide the username of a user who has the permission to connect and back up alarms.
  7. Select Test Connection to check if the source database is active and the information is accurate.
    The Begin Migrator button is activated.
  8. Select Begin Migrator.
    The alarms and evens data is restored. The count of the rows that are restored appears.