Jump to: navigation, search

Difference between revisions of "HowTo:Install UBIK Database"


(See also)
 
(34 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Configuration of SQL database ==
+
All content and configuration data of {{UBIK}} is managed in a [http://www.microsoft.com/en-us/sqlserver/default.aspx Microsoft SQL] database (2008 R2 or newer). Once the SQL server engines is installed successfully, an administrator can set up a new {{UBIK}} database simple using the available release database.
[[File:UI_MSSQL.png|thumb|alt=Alt text|Connect to MS SQL Management Studio]]
+
[[File:UI_RestoreDB.png|thumb|alt=Alt text|Restore database]]
+
* Microsoft SQL Server 2008 R2
+
  
# Copy the file ''UBIK.RELEASE.bak'' to the local drive
+
[[File:UI_SettingUpUBIKDatabase_01.png|thumb|alt=Microsoft SQL Server Management Studio|Microsoft SQL Server Management Studio]]
# Start the application MS SQL Management Studio and connect to the database server
+
== Setting up {{UBIK}} database ==
# Navigate to "Databases" and add a new database
+
# Start the ''Microsoft SQL Server Management Studio'' and connect to the database server
# Choose "Tasks / Restore / Database" from the context menu
+
# Navigate to ''Databases'' and right click on ''Databases''→ select ''New database...''
## Choose the newly created database in the setting "In database"
+
# Right click on the newly created database and choose ''Tasks → Restore → Database'' from the context menu
## Choose the copied backup file in "From media"
+
## Choose the newly created database in the setting ''In database''
## Check the "Restore" flag
+
## Choose the copied backup file in ''From media''
# Switch to the options-slider and check "Overwriting actual data"
+
## Check ''Restore'' of the according backup set <br/> [[File:Restore Database.PNG| 440px|border]]
# Finish the process by clicking the "OK"
+
# Switch to the options-slider and check ''Overwriting actual data'' (if necessary)
 +
# Finish the process by clicking {{key press|OK}}
  
==See also==
 
* [[Installation_UBIK_Studio|Set up {{UBIK}} Studio]]
 
* [[Microsoft_IIS_Server|Set up Microsoft IIS Server]]
 
  
[[Category:UBIK Studio]]
+
{{Attention|Use maintenance plans for periodic backup of your own and the system databases!}}
[[Category:Configuration]]
+
 
 +
== Requirements ==
 +
=== Database user ===
 +
The database user configured in {{UBIK}} Studio used to connect to the database needs
 +
* to have the role ''sys.admin'' assigned
 +
* to be marked as ''Database owner'' (dbo) of the according {{UBIK}} database
 +
 
 +
=== Windows firewall ===
 +
For a non-local SQL server make sure that the SQL server port (default: 1433) is unlocked by the Windows firewall Inbound and Exbound rules.
 +
 
 +
== See also ==
 +
* [[FAQ:Installation_and_Configuration#Network|FAQ: Installation and Configuration / Network]]
 +
 
 +
[[Category:How-To|Install UBIK Database]]
 +
[[Category:Installing|Install UBIK Database]]

Latest revision as of 08:52, 9 January 2020

All content and configuration data of UBIK® is managed in a Microsoft SQL database (2008 R2 or newer). Once the SQL server engines is installed successfully, an administrator can set up a new UBIK® database simple using the available release database.

Microsoft SQL Server Management Studio
Microsoft SQL Server Management Studio

Setting up UBIK® database

  1. Start the Microsoft SQL Server Management Studio and connect to the database server
  2. Navigate to Databases and right click on Databases→ select New database...
  3. Right click on the newly created database and choose Tasks → Restore → Database from the context menu
    1. Choose the newly created database in the setting In database
    2. Choose the copied backup file in From media
    3. Check Restore of the according backup set
      Restore Database.PNG
  4. Switch to the options-slider and check Overwriting actual data (if necessary)
  5. Finish the process by clicking OK


IC Attention.pngUse maintenance plans for periodic backup of your own and the system databases!

Requirements

Database user

The database user configured in UBIK® Studio used to connect to the database needs

  • to have the role sys.admin assigned
  • to be marked as Database owner (dbo) of the according UBIK® database

Windows firewall

For a non-local SQL server make sure that the SQL server port (default: 1433) is unlocked by the Windows firewall Inbound and Exbound rules.

See also