Migrate Alarms and Events Using the Utility

Before you begin

Back up the alarms and events data.

Procedure

  1. Run the Proficy.Historian.AandE.Migration.exe file. By default, it is located at C:\Program Files (x86)\Proficy\Proficy DataBase.
    The Proficy Historian Alarm and Event Data Migration window appears.
  2. Select Migrate Alarms and Events Backup.
  3. Enter values as described in the following table.
    Field Description
    Backup File Path Enter the location of the backup file. If your server is running on a remote computer, enter a path that exists on the remote computer.
    SQL Server Instance Name Enter the SQL server instance name in which the backup file is stored.
    Database Name Enter the name of the database using which you have backed up the data. Typically, this will be the same as the SQL Server you are currently using.
    Use Windows Authentication or Use SQL Authentication Select either of these options to specify the type of authentication you want to use.
    User Id Depending on whether you have selected Use Windows Authentication or Use SQL Authentication, enter the Windows or SQL server username to connect to the SQL server. Ensure that this user has the permission to restore alarms.
    Password Depending on whether you have selected Use Windows Authentication or Use SQL Authentication, enter the Windows or SQL server password to connect to the SQL server.
  4. Select Test Connection to verify that the source database is active and the information is accurate.
    Note: You can find this information in the registry under: HKEY_LOCAL_MACHINE\SOFTWARE\Intellution, Inc.\iHistorian\Services\AlarmArchiver.
    The Begin Migration is activated and the alarm data is restored.
  5. Select Begin Migration.
    The data is migrated.