Migration

If a version is updated to with a greater second version number digit, it may be necessary to make changes to the database schema. For such cases, a command line tool is provided to which the currently used version, the version that is being migrated to and the connection data for the database are sent. The program then makes the changes to the database successively up to the desired version.

The tool is run as main class of the migration-tool-[VERSION].jar. This Jjar 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:

1. Specification of the currently used version

2. Specification of the version that is being migrated to

3. Connection URL to the database

4. A user name for the database

5. A password for the specified user

6. The package name of the JDBC driver that is to be used

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