Create Forest Database: Difference between revisions

← Older edit

Latest revision as of 12:36, 17 November 2014

Languages:

English • svenska

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

@@ Line 1: / Line 1: @@
 {{Languages}}
-See also [[Install existing database]]
+See http://heurekaslu.org/help/en/index.html?skapa_databas.htm
-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 also [[Install Existing Database]]
-# 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\.
+# Start StandWise, PlanWise or RegWise.
-# 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.
+# Select "Create Forest Database" from the "Data Management" menu
-# Enter the server name under the "Server":
+# Enter the server name under "Server":
-# # If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
+## 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 install the database locally, or the server name if you are installing on a remote server.
+## If you have the commercial version of SQL Server, enter "LOCALHOST" if you are about to install the database locally
-# If you install locally, leave "Authentication" mode equal to "Windows authentication".
+## If you are about to install the database on a remote server, enter the remote server name
-# In "Database name", type a database name (without blanks)
+# If you install locally, leave "Authentication" mode equal to "Windows Authentication"
-# 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.
+# In "Database name", enter a database name (without blanks)
-# Click on "Create Database" and wait until ready.
+# 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]]
@@ Line 22: / Line 25: @@
 [[Category:Install]]
 [[Category:Database]]
+-->

Create Forest Database: Difference between revisions

Latest revision as of 12:36, 17 November 2014

Navigation menu

Search