Upgrade ALBPM 5.5 SQL Server DBs

This section explain how to upgrade the structure of ALBPM 5.5 databases on Microsoft SQL Server.

Follow these steps if you are upgrading from ALBPM version 5.5.x (and not 5.7.x) using Microsoft SQL Server as the database server.

You need a database user with enough privileges to perform SQL DDL (Data Definition Language) operations (like ALTER, CREATE and DROP statements) on the ALBPM databases.

  1. Locate the migration SQL scripts for your database.

    ALBPM Enterprise 6.0.3+ (on the first Hotfix) includes SQL scripts for upgrading the structure of ALBPM 5.5 databases on Microsoft SQL Server. These scripts are located under the following directory: <ALBPM_DIR>/conf/migration/ms-sql/. Refer to Upgrade Scripts for 5.5 on SQL Server for a detailed list of files included.

    You have one SQL script for each ALBPM database to upgrade:
    • migration_directory.sql (for ALBPM Directory database)
    • migration_engine.sql (for ALBPM Engine database)
    • migration_archiving.sql (for ALBPM Archiving database)
    • migration_bam.sql (for ALBPM Business Activity Monitoring database)
    • migration_dataMart.sql (for ALBPM DataMart database -formerly "DataStore" for historical reporting-)
  2. Launch Microsoft SQL 2005 Management Studio
  3. For each ALBPM 5.5 database, follow the steps below to run the SQL migration script.
    1. Open the SQL script file.

      From the menu select: File > Open > File... and select the .sql file.

    2. Enter the connection information to the database
    3. Modify the SQL script to match your database name and user ID.
      1. Modify the USE fuego_55_xxxxx line of the script to use the name of your database. Example: If the name of your directory database is my_fuego_dir, the line should read: 
        USE my_fuego_dir
      2. Modify the SET @sql_user = 'fuego_55_xxxxx' line of the script to use your database user ID. Example: If the ID of your database use is my_fuego_user, the line should read: 
        SET @sql_user = 'my_fuego_user'
    4. Review the script and ensure it fits your environment.

      Each .sql script may include specific instructions on how it works and how to use it. Make sure you read them before executing any SQL statements.

    5. Execute the SQL script to upgrade the database structure.

      From the menu, select: Query > Execute.

    After the execution of each script, you should see a Query Executed Successfully message in the status bar at the bottom of the screen.

Parent topic: Upgrade ALBPM 5.5 DB structures