Database Upgrade
Before upgrading Lynx version 1.5.0 (or below) to Lynx 1.5.1 (or above), follow this procedure to upgrade the database that Lynx is using.
Note
The upgrade procedure is also applicable for systems using XA and Lynx together.
The SQL script that will need to be run is included in the initially, received package and is named "lynx-db-upgrade.sql". If it cannot be located in the package, please contact your Identity Automation representative to obtain the SQL script.
Important
In order to perform the database upgrade, it is necessary to run the SQL script. Therefore, the user will need to have the ability and permissions to run a SQL script to modify the database that Lynx is using.
It is best to perform the database upgrade before upgrading the Lynx software. This will provide the quickest Lynx upgrade path and is especially beneficial for environments with multiple instances of Lynx that need upgrading that are all pointed to the same database.
Upgrade Procedure
Follow the proceeding steps to perform the upgrade.
Note
The following procedure can only be performed by a user who has the permissions to modify the schema of tables in the Lynx or XA database.
Additionally, it is recommended for users familiar with Microsoft SQL Server Management Studio.
Start SQL Server Management Studio
Connect to the Lynx database.
Note
If using XA, connect to the XA database.
Open the "lynx-db-upgrade.sql" script.
Ensure that the correct database is selected.
Execute the script.
The script will quickly run. After it is done, a message will display stating it successfully completed. The database is now upgraded and is ready for the Lynx server instance(s) upgrade.