Difference between revisions of "Install database"

From Heureka Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{Languages}}
 
{{Languages}}
  
−
The input database must be installed, 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.
+
See http://heurekaslu.org/help/en/index.html?skapa_databas.htm
  
−
Instructions:
 
−
#Download an empty backup file (. Bak) of [ftp://salix.slu.se/Download/Heureka/Databases/ SLU FTP server] and save to your hard disk, for example, C:\TEMP\. If you are installing on a server, the file must be available locally on the server, and you must be logged on the server. You can also use another backup of a database that already contains data, if you have access to such.
 
−
# Use alternative 1 or 2 below
 
  
−
== Alternative 1: Use function in PlanStart to install database ==
+
<!--
−
[[Create a forest database | Create Forest Database]]
+
==Create new or demo database==
 +
PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically.
  
−
If this does not work, then try the options below.
+
==Install existing database==
  
−
== Alternative 2: Run the "Restore" in SQL Server Management Studio ==
+
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.
 +
Use the "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 20: 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. 3: Installing an .mdf file via the "Attach"-option in SQL Server Management Studio ==
+
'''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 27: Line 29:
 
# Click "Add" and select the .ndf file.
 
# Click "Add" and select the .ndf file.
 
# In the "Database details', check and if necessary edit the file path to valid ones.
 
# In the "Database details', check and if necessary edit the file path to valid ones.
 +
 +
[[Category:Reference Manual]]
 +
[[Category:Software]]
 +
[[Category:Install]]
 +
[[Category:Database]]
 +
 +
-->

Latest revision as of 13:36, 17 November 2014

Languages Languages: 

[[::Install database|English]]  • [[::Install database/sv|svenska]]

See http://heurekaslu.org/help/en/index.html?skapa_databas.htm


Retrieved from "https://www.heurekaslu.se/w/index.php?title=Install_database&oldid=7242"