Upgrade Scripts for 5.5 on SQL Server

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/.

Here is the list of files included for upgrading ALBPM 5.5 Microsoft SQL Server databases to ALBPM 6.0:

  ms-sql/
  |-- ArchivingDatabaseDifferencesReport5511to602.html
  |-- BamDatabaseDifferencesReport5511to602.html
  |-- DataMartDatabaseDifferencesReport5511to602.html
  |-- EngineDatabaseDifferencesReport5511to602.html
  |-- FDIDatabaseDifferencesReport5511to602.html
  |-- migration_archiving.sql
  |-- migration_bam.sql
  |-- migration_dataMart.sql
  |-- migration_directory.sql
  `-- migration_engine.sql

The .sql files are the SQL scripts you must execute for converting the 5.5 schemas to 6.0.2, as described in Upgrade ALBPM 5.5 SQL Server DBs.

The .html files are reports of the schema differences between version 5.5 and 6.0, included for your reference.