If a version is updated to a version with a higher second version number digit, changes to the database schema may be necessary. For this case, a command line tool is provided, to which the currently used version, the version to migrate to, and the database connection data are passed. The program then successively makes the changes to the database up to the desired version.
The tool is run as the main class of migration-tool-[VERSION].jar. This Jar is located in the subfolder migration of the delivery package.
To run the tool, the following command can be used (Windows OS):
java -cp migration-tool-[VERSION].jar de.signotec.ssu.migration.DBMigration
The tool queries all required parameters before the start. These are, in sequence:
-
Specification of the currently used version
-
Specification of the version that is being migrated to
-
Connection URL to the database
-
A username for the database
-
A password for the specified user
-
The package name of the JDBC driver that is to be used
-
Specification of the SQL dialect to be used by Hibernate as package name
-
The database user that is used requires the right to change tables of the signoSign/Universal schema.
-
The parameters for the database connection can be found in the Hibernate configuration.
-
The used database must be started to enable the migration to be performed. This means that if SSU is used in the preset state, SSU must be started to enable the H2 database to run.