Identity Manager uses a tool called Liquibase to update the database. This allows database changes to be made independently of the underlying database type, therefore making it easy to maintain the database schema for different databases with maximum flexibility.
To update the database:
Stop the Tomcat service:
In the General tab, click Stop.
Open the following file:
update_db.bat, in the delivery directory db_update
Adjust the URL
, USER
, and PASSWORD
parameters to reflect the database. See Database properties file.
Save the file.
Run the batch file. Note that the server on which these scripts are run requires access to the database server. If the script is run on the application server, this should not be a problem because the connection is also needed at runtime.
After successful execution, the following message is displayed on the console:
Liquibase Update Successful
Restart Tomcat to establish the database connection.