Create System-DB on DB-Server without EngineConfigurationUI

The Configuration UI uses 3 SQL scripts that can be used. The creation scripts are in a engine JAR. Get the them as follows:

1. Open the engine JAR /lib/ivy/ch.ivyteam.ivy.persistence-XXX.jar with a ZIP viewer like 7-ZIP
2. Navigate to ch\ivyteam\ivy\persistence\db\mssqlserver\
3. Extract the 3 files that start with "create": CreateBaseDatabase.sql, CreateDatabase.sql, CreateSystemApplication.sql

Pass the 3 scripts to your DB-Admin. The admin should create a new DB and execute the scripts in order:

1. CreateBaseDatabase.sql
2. CreateDatabase.sql: within this script the parameter {0} must be replaced with the name of the DB that was created by the DB-Admin. Execute the script and restart the Sql Server Management Studio. A prompt will ask to close open transactions. Confirm this prompt.
3. CreateSystemApplication.sql

Aftewards you can can connect to the System-DB with the AxonIvyEngineConfigurationUi and set the admin user + connection ports.

Hint: Likewise the DB creation scripts are also available for other System-DBs like MySql, Postgre, etc. and the install steps are similiar to MS-Sql.