Migrating Event Collector Data for Microsoft SQL Server

If the database you are using is Microsoft SQL Server, you must install and run the migration stored procedure for Microsoft SQL Server to migrate the Event Collector data.

1. Log in to Microsoft SQL Server Management Studio as your TIBCO ActiveMatrix BPM Runtime Database user (default: bpmuser) and select your BPM database.
2. Import the install-migration-tools.sql file using the File > Open > File menu.
3. Click the Execute button or use the F5 shortcut key to install the stored procedures and create the ec_migration table used to migrate the Event Collector data.
4. You may have large amounts of event data to migrate, depending on the size of your system. Therefore, the amxbpm_migrate_events stored procedure enables you to specify the number of events to migrate, and the commit batch size. Execute the command multiple times to migrate the data. You can either:
   • Select the amxbpm_migrate_events stored procedure and either, click the Execute button or use the F5 shortcut key to execute the stored procedure.
   • or call the amxbpm_migrate_events stored procedure directly. For example:

     CALL amxbpm_migrate_events(parameter1, parameter2)

   where:

   • parameter1 is the number of events to be migrated.
   • parameter2 is the batch size to commit.

   The default is 20,000 events in batches of 500. This results in the most recent 20,000 events being migrated. Repeat this command until all your data is migrated. For example:

   CALL amxbpm_migrate_events(20000, 500)

5. Once your data has migrated, select the remove-migration-tools.sql and click the Execute button or use the F5 shortcut key to remove the migration tools used to migrate the Event Collector data.