Difference between revisions of "Create Forest Database"

From Heureka Wiki
Jump to navigation Jump to search
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.
+
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.
  
−
In menu "Tools" > "Create Forest Database":
+
# Start PlanStart
−
 
+
# Select "Create Database Forest" from the "Tools" menu
−
#"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, backups are made available on a ftp-server).
+
# Click the "Browse"-button and select the directory where the backup file is located, eg C:\TEMP\.
−
#In "Settings..." you give the additional information necessary, e.g. "LOCALHOST" or "LOCALHOST\SQLEXPRESS", depending on the installed SQL Server.
+
# 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.
−
#Press "Create database" and wait (might take a while, depending on the size of the backup).
+
# Enter the server name under the "Server":
−
+
# # If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
−
Now you should have a local forest database. It can be empty or with some data (for testing) 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 [[User%27s_guide_to_PlanStart|User's guide to PlanStart]].
+
# # 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.
−
 
+
# If you install locally, leave "Authentication" mode equal to "Windows authentication".
−
*'''Note'''
+
# In "Database name", type a database name (without blanks)
−
:The first thing to do is to check the version of the created database. Perhaps some upgrade scripts needs to be run to make the database compatible with other Heureka softwares.
+
# 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.
 +
# Click on "Create Database" and wait until ready.
  
 
[[Category:Software]]
 
[[Category:Software]]
 
[[Category:Install]]
 
[[Category:Install]]
 
[[Category:Database]]
 
[[Category:Database]]

Revision as of 15:15, 15 February 2010

A "Restore"-procedure, executed in SQL Server Management Studio to create a local forest database, is described 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.

  1. Start PlanStart
  2. Select "Create Database Forest" from the "Tools" menu
  3. Click the "Browse"-button and select the directory where the backup file is located, eg C:\TEMP\.
  4. 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.
  5. Enter the server name under the "Server":
  6. # If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
  7. # 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.
  8. If you install locally, leave "Authentication" mode equal to "Windows authentication".
  9. In "Database name", type a database name (without blanks)
  10. 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.
  11. Click on "Create Database" and wait until ready.
Retrieved from "https://www.heurekaslu.se/w/index.php?title=Create_Forest_Database&oldid=3906"