Difference between revisions of "Create Forest Database"

From Heureka Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{Languages}}
 
{{Languages}}
  
−
A "Restore"-procedure, executed in SQL Server Management Studio to create a local forest database, is described [[Install_SQL_Server_Express|here]]. A corresponding functionality is now available in PlanStart. In both cases the SQL Server software needs to be [[Install SQL Server | installed]] on the computer, while the built-in functionality seems to be compatible only with SQL Server 2005.
 
  
−
# Start PlanStart
+
See http://heurekaslu.org/help/en/index.html?skapa_databas.htm
−
# Select "Create Database Forest" from the "Tools" menu
+
 
−
# Click the "Browse"-button and select the directory where the backup file is located, eg C:\TEMP\.
+
<!--
−
# Select the backup file and click "Open". Note: Windows Vista may be sensitive to where the backup file is put, because SQL Server in Vista has restricted reading access. Anyhow, C:\temp\ should be OK.
+
 
−
# Enter the server name under the "Server":
+
See also [[Install Existing Database]]
−
# # If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
+
 
−
# # If you have the commercial version of SQL Server, enter "localhost" if you install the database locally, or the server name if you are installing on a remote server.
+
# Start StandWise, PlanWise or RegWise.
−
# If you install locally, leave "Authentication" mode equal to "Windows authentication".
+
# Select "Create Forest Database" from the "Data Management" menu
−
# In "Database name", type a database name (without blanks)
+
# Enter the server name under "Server":
−
# Click the "Browse ..."-button next to "Location of data file", and specify a location where you want to save the database. See (4) above concerning problems with Vista.
+
## If you have the free version, SQL Server 2005 Express, enter "LOCALHOST\SQLEXPRESS" if you are about to install the database locally
−
# Click on "Create Database" and wait until ready.
+
## If you have the commercial version of SQL Server, enter "LOCALHOST" if you are about to install the database locally
 +
## If you are about to install the database on a remote server, enter the remote server name
 +
# If you install locally, leave "Authentication" mode equal to "Windows Authentication"
 +
# In "Database name", enter a database name (without blanks)
 +
# Check "Include demo data" if you want to create a database with some demonstration data. Leave it unchecked to create an empty database
 +
# Click the "Create Database"-button and await success
 +
 
 +
''NB: The folder where the forest database is locally stored (e.g., C:\PROGRAM\MICROSOFT SQL SERVER\MSSQL10.MSSQLSERVER\MSSQL\DATA) can not be in "Compression mode". Right-click the DATA folder, select "Properties" and "Advanced settings..." and make sure "Compress content..." is unchecked.''
  
 
[[Category:Reference Manual]]
 
[[Category:Reference Manual]]
Line 19: Line 25:
 
[[Category:Install]]
 
[[Category:Install]]
 
[[Category:Database]]
 
[[Category:Database]]
 +
 +
-->

Latest revision as of 13:36, 17 November 2014

Languages Languages: 

[[::Create Forest Database|English]]  • [[::Create Forest Database/sv|svenska]]


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


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