With the AxonIvyEngineConfigurationUI I can create a MS-SQL DB on my developer workstation. In production I do not have enough rights to create a System-DB on the SQL Server. So our operations team must create the empty System-DB without Java on the DB-Server. Is there a dump that can be used to for this task?

asked 17.02.2015 at 14:08

SupportIvyTeam's gravatar image

SupportIvyTeam ♦♦
1.3k90110118
accept rate: 77%

edited 17.02.2015 at 14:36

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
8.5k21851


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

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

link

answered 17.02.2015 at 14:19

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
8.5k21851
accept rate: 69%

edited 17.02.2015 at 14:40

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×31
×14

Asked: 17.02.2015 at 14:08

Seen: 1,327 times

Last updated: 17.02.2015 at 14:40