Difference between revisions of "HowTo:Install UBIK Database"
| Line 11: | Line 11: | ||
# Switch to the options-slider and check "Overwriting actual data" | # Switch to the options-slider and check "Overwriting actual data" | ||
# Finish the process by clicking the "OK" | # Finish the process by clicking the "OK" | ||
| + | |||
| + | == Requirements == | ||
| + | * Database user must have role sys.admin | ||
| + | * Database user has to be dbo of {{UBIK}} database | ||
| + | * If Windows firewall is active, the SQL server port 1433 must be unlocked | ||
==See also== | ==See also== | ||
Revision as of 11:51, 20 September 2013
Configuration of SQL database
File:UI MSSQL.png
Connect to MS SQL Management Studio
File:UI RestoreDB.png
Restore database
- Copy the file UBIK.RELEASE.bak to the local drive
- Start the application MS SQL Management Studio and connect to the database server
- Navigate to "Databases" and add a new database
- Choose "Tasks / Restore / Database" from the context menu
- Choose the newly created database in the setting "In database"
- Choose the copied backup file in "From media"
- Check the "Restore" flag
- Switch to the options-slider and check "Overwriting actual data"
- Finish the process by clicking the "OK"
Requirements
- Database user must have role sys.admin
- Database user has to be dbo of UBIK® database
- If Windows firewall is active, the SQL server port 1433 must be unlocked
