Difference between revisions of "Create Forest Database"

From Heureka Wiki
Jump to navigation Jump to search
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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 installed on the computer, while the built-in functionality seems to be compatible only with SQL Server 2005.
+
{{Languages}}
  
In menu "Tools" > "Create Forest Database":
 
  
#"Browse..." to the catalogue on your computer holding the backup-file of a forest database. If you are missing such file, contact a Heureka administrator (usually, available on a ftp-server).
+
See http://heurekaslu.org/help/en/index.html?skapa_databas.htm
#In "Settings..." you give the additional information necessary, e.g. "LOCALHOST" or "LOCALHOST\SQLEXPRESS", depending on the installed SQL Server.
 
#Press "Create database" and wait (might take a while, depending on the size of the database-backup.
 
 
Now you should have a local forest database. This might be empty or with some testdata already imported. There are several possibilities to import new data and set up an analysis area of your own. Read more about this in other parts of the [[PlanStart User's Guide]]
 
  
*'''Note'''
+
<!--
:Be careful when using imputed plot data/simulated single tree-data based on a stand register of uncertain quality. Any systematic errors here will comply and might even grow with the prognoses, with negative impact on the planning result's reliability. In strategic planning, this carefulness should increase with the length of the planning period.
+
 
 +
See also [[Install Existing Database]]
 +
 
 +
# Start StandWise, PlanWise or RegWise.
 +
# Select "Create Forest Database" from the "Data Management" menu
 +
# Enter the server name under "Server":
 +
## If you have the free version, SQL Server 2005 Express, enter "LOCALHOST\SQLEXPRESS" if you are about to install the database locally
 +
## 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:Software]]
 +
[[Category:Install]]
 +
[[Category:Database]]
 +
 
 +
-->

Latest revision as of 13:36, 17 November 2014


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