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 ![scripts in JAR][1] 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. ![replace command][2] 4. 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. [1]: http://answers.axonivy.com/upfiles/createScripts.png [2]: http://answers.axonivy.com/upfiles/setQueryParameter.png

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 ![scripts in JAR][1] Pass the 3 scripts to your DB-Admin. The admin should create a new DB and execute the scripts in order: 1. CreateBaseDatabase.sql -> restart 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. ![replace command][2] 4. CreateSystemApplication.sql Aftewards you can can connect to the System-DB with the AxonIvyEngineConfigurationUi and set the admin user + connection ports. [1]: http://answers.axonivy.com/upfiles/createScripts.png [2]: http://answers.axonivy.com/upfiles/setQueryParameter.png

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 ![scripts in JAR][1] Pass the 3 scripts to your DB-Admin. The admin should create a new DB and execute the scripts in order: 1. CreateBaseDatabase.sqlCreateBaseDatabase.sql -> restart 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 DB-Admin. Execute the script and restart the Sql Server Management Studio. A prompt will ask to close open transactions. Confirm this prompt. ![replace command][2] 4. CreateSystemApplication.sql Aftewards you can can connect to the System-DB with the AxonIvyEngineConfigurationUi and set the admin user + connection ports. [1]: http://answers.axonivy.com/upfiles/createScripts.png [2]: http://answers.axonivy.com/upfiles/setQueryParameter.png

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.sqlCreateSystemApplication.sql ![scripts in JAR][1] 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.sqlCreateDatabase.sql: within this script the parameter {0} must be replaced with the name of the DB that was created by the DB-Admin ![replace command][2] 3. 4. CreateSystemApplication.sql Aftewards you can can connect to the System-DB with the AxonIvyEngineConfigurationUi and set the admin user + connection ports.ports. [1]: http://answers.axonivy.com/upfiles/createScripts.png [2]: http://answers.axonivy.com/upfiles/setQueryParameter.png

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 3. CreateSystemApplication.sql Aftewards you can can connect to the System-DB with the AxonIvyEngineConfigurationUi and set the admin user + connection ports.