MSSQL
6.2.1.4. MSSQL as Airlock IAM database

This page describes how to use an MSSQL database with the Airlock IAM database schema.

The chosen data layer has to be well managed and monitored. IAM is not responsible for operation and backup/recovery. For productive usage, the data layer should be clustered.

Schema creation and upgrade

SQLs scripts for MSSQL databases are available here:

SQL File
Description
Creates tables used for Airlock IAM.
Upgrades IAM 7.1 database schema for release IAM 7.2.
Upgrades IAM 7.2 database schema for release IAM 7.3.
Upgrades IAM 7.3 database schema for release IAM 7.4.
Upgrades IAM 7.4 database schema for release IAM 7.5.
Upgrades IAM 7.5 database schema for release IAM 7.6.
Inserts an administrator "admin" with password "password" (works with demo configuration).

For performance tuning hints, see: 7.6. Performance tuning and scaling best practices

Further information and links