Difference between revisions of "Install database"
Jump to navigation
Jump to search
| (4 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{Languages}} | + | {{Languages|Install_database}} |
| + | See http://heurekaslu.org/help/en/index.html?skapa_databas.htm | ||
| + | |||
| + | |||
| + | <!-- | ||
==Create new or demo database== | ==Create new or demo database== | ||
PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically. | PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically. | ||
| Line 6: | Line 10: | ||
==Install existing database== | ==Install existing database== | ||
| − | + | You can install an existing database either locally on <code>localhost</code> or on a central server (like <code>server1.mycompany.com</code>). It is assumed that you have [[Install SQL Server | installed]] or have access to SQL Server. | |
| − | + | '''Prerequisite''': A backup file (. Bak) from an existing database. | |
| − | Prerequisite: A backup file (. Bak) from an existing database. | + | Use the "Restore" function i SQL Server Management Studio to install the database: |
| − | Use "Restore" function i SQL Server Management Studio to install the database: | ||
# Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name). | # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name). | ||
# Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces) | # Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces) | ||
| Line 18: | Line 21: | ||
# In "Options", select "Overwrite ..." and change the "Restore as ..." to valid paths (folders must exist on your computer if you install locally, and on the server if you install on a remote server. | # In "Options", select "Overwrite ..." and change the "Restore as ..." to valid paths (folders must exist on your computer if you install locally, and on the server if you install on a remote server. | ||
| − | '''Alternative:''' | + | '''Alternative:''' Install an .mdf file via the "Attach"-option in SQL Server Management Studio. |
| + | |||
This alternative is available if you have an -mdf-file instead of a backup (.bak) file. | This alternative is available if you have an -mdf-file instead of a backup (.bak) file. | ||
# Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name). | # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name). | ||
| Line 30: | Line 34: | ||
[[Category:Install]] | [[Category:Install]] | ||
[[Category:Database]] | [[Category:Database]] | ||
| + | |||
| + | --> | ||
