Migrate data from the A2ALMDB database to history blocks

You can migrate the alarm and event data in the A2ALMDB database to history blocks. Before you start the migration, be sure that:

• The Historian is running.

• The user account used to connect to the A2ALMDB database is a member of the aaAdministrators group. Members of the aaPowerUsers group can also run the utility if they are granted the VIEW DATABASE STATE permission.

• The Historian is configured to store alarms and events to history blocks.

• There is at least one record in the A2ALMDB database.

At the end of the migration, the following migration statistics are logged to the ArchestrA Logger:

• Number of alarms and events in the database

• Number of events forwarded to history block storage

• Number of events/second forwarded to history block storage

To migrate alarm and event data

1. On the Start menu, click All Programs, click AVEVA, click Historian and then click Migrate A2ALMDB. The Migrating Alarm and Event to Block Storage utility appears.

   

2. In the SQL Login Information area, specify a user account that has administrative access to the A2ALMDB database.

3. Click Connect.

4. Click Start to begin the migration.