Create Forest Database: Difference between revisions

From Heureka Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
No edit summary
Line 3: Line 3:
See also [[Install Existing Database]]
See also [[Install Existing Database]]


 
(New since version 1.0.3).  
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
# Start PlanStart
# Select "Create Database Forest" from the "Tools" menu
# 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\.
# Enter the server name under "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.
## If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
# Enter the server name under the "Server":
## 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 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.
# If you install locally, leave "Authentication" mode equal to "Windows authentication".
# If you install locally, leave "Authentication" mode equal to "Windows authentication".
# In "Database name", type a database name (without blanks)
# In "Database name", type a database name (without blanks).
# 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.
# Select whether you want an empty database, or a database with som demonstration data.
# Click on "Create Database" and wait until ready.
# Click on "Create Database" and wait until ready.


Revision as of 12:26, 3 March 2010

Languages Languages: 

English  • svenska

See also Install Existing Database

(New since version 1.0.3).

  1. Start PlanStart
  2. Select "Create Database Forest" from the "Tools" menu
  3. Enter the server name under "Server":
    1. If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
    2. 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.
  4. If you install locally, leave "Authentication" mode equal to "Windows authentication".
  5. In "Database name", type a database name (without blanks).
  6. Select whether you want an empty database, or a database with som demonstration data.
  7. Click on "Create Database" and wait until ready.
Retrieved from "https://www.heurekaslu.se/w/index.php?title=Create_Forest_Database&oldid=4199"