Install database - Revision history

Osskyn at 09:19, 26 November 2024

2024-11-26T09:19:19Z

Peder at 11:36, 17 November 2014

2014-11-17T11:36:21Z

Peder: moved Install Existing Database to Install database over redirect

2010-03-03T11:57:22Z

moved Install database to Install database over redirect

Peder: /* Install existing database */

2010-03-03T11:45:23Z

Install existing database

Peder: /* Install existing database */

2010-03-03T11:43:33Z

Install existing database

Peder at 11:42, 3 March 2010

2010-03-03T11:42:13Z

Peder at 11:37, 3 March 2010

2010-03-03T11:37:37Z

Peder at 11:36, 3 March 2010

2010-03-03T11:36:34Z

Peder at 13:29, 15 February 2010

2010-02-15T13:29:23Z

Peder at 13:19, 15 February 2010

2010-02-15T13:19:33Z

← Older revision		Revision as of 09:19, 26 November 2024
Line 1:		Line 1:
−	{{Languages}}	+	{{Languages\|Install_database}}

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

@@ Line 1: / Line 1: @@
 {{Languages}}
 ==Create new or demo database==
 PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically.
@@ Line 30: / Line 34: @@
 [[Category:Install]]
 [[Category:Database]]

@@ Line 9: / Line 9: @@
 '''Prerequisite''': A backup file (. Bak) from an existing database.
-Use "Restore" function i SQL Server Management Studio to install the database:
+Use the "Restore" function i SQL Server Management Studio to install the database:
 # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
 # Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
@@ Line 17: / Line 17: @@
 # In "Options", select "Overwrite ..." and change the "Restore as ..." to valid paths (folders must exist on your computer if you install locally, and on the server if you install on a remote server.
-'''Alternative:''' Installing an .mdf file via the "Attach"-option in SQL Server Management Studio ==
+'''Alternative:''' Install an .mdf file via the "Attach"-option in SQL Server Management Studio.
 This alternative is available if you have an -mdf-file instead of a backup (.bak) file.
 # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).

@@ Line 6: / Line 6: @@
 ==Install existing database==
-The input database must be installed, either locally on <code>localhost</code> or on a central server (like <code>server1.mycompany.com</code>). It is assumed that you have [[Install SQL Server | installed]] or have access to SQL Server.
+You can install an existing database either locally on <code>localhost</code> or on a central server (like <code>server1.mycompany.com</code>). It is assumed that you have [[Install SQL Server | installed]] or have access to SQL Server.
-Instructions:
+'''Prerequisite''': A backup file (. Bak) from an existing database.
 Use "Restore" function i SQL Server Management Studio to install the database:
 # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).

@@ Line 1: / Line 1: @@
 {{Languages}}
-<div>
+==Create new or demo database==
-;Note: PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically.
+PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically.
-</div>
 The input database must be installed, either locally on <code>localhost</code> or on a central server (like <code>server1.mycompany.com</code>). It is assumed that you have [[Install SQL Server | installed]] or have access to SQL Server.
 Instructions:
-#Download an empty backup file (. Bak) of [ftp://salix.slu.se/Download/Heureka/Databases/ SLU FTP server] and save to your hard disk, for example, C:\TEMP\. If you are installing on a server, the file must be available locally on the server, and you must be logged on the server. You can also use another backup of a database that already contains data, for example the demo database called Heureka_Demo_Mini, also available at the ftp-server.
+Prerequisite: A backup file (. Bak) from an existing database.
+Use "Restore" function i SQL Server Management Studio to install the database:
 # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
 # Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
@@ Line 25: / Line 18: @@
 # In "Options", select "Overwrite ..." and change the "Restore as ..." to valid paths (folders must exist on your computer if you install locally, and on the server if you install on a remote server.
-== Alternative. 3: Installing an .mdf file via the "Attach"-option in SQL Server Management Studio ==
+'''Alternative:''' Installing an .mdf file via the "Attach"-option in SQL Server Management Studio ==
 This alternative is available if you have an -mdf-file instead of a backup (.bak) file.
 # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).

← Older revision	Revision as of 11:57, 3 March 2010
(No difference)

← Older revision		Revision as of 11:36, 3 March 2010
Line 1:		Line 1:
	{{Languages}}		{{Languages}}
		+
		+	Note! PlanStart version 1.0.3 and later lets you [[Create Forest Database \| create a database]] autmatically.

	The input database must be installed, either locally on <code>localhost</code> or on a central server (like <code>server1.mycompany.com</code>). It is assumed that you have [[Install SQL Server \| installed]] or have access to SQL Server.		The input database must be installed, either locally on <code>localhost</code> or on a central server (like <code>server1.mycompany.com</code>). It is assumed that you have [[Install SQL Server \| installed]] or have access to SQL Server.

← Older revision		Revision as of 13:29, 15 February 2010
Line 28:		Line 28:
	# Click "Add" and select the .ndf file.		# Click "Add" and select the .ndf file.
	# In the "Database details', check and if necessary edit the file path to valid ones.		# In the "Database details', check and if necessary edit the file path to valid ones.
		+
		+	[[Category:Reference Manual]]
		+	[[Category:Software]]
		+	[[Category:Install]]
		+	[[Category:Database]]

@@ Line 4: / Line 4: @@
 Instructions:
-#Download an empty backup file (. Bak) of [ftp://salix.slu.se/Download/Heureka/Databases/ SLU FTP server] and save to your hard disk, for example, C:\TEMP\. If you are installing on a server, the file must be available locally on the server, and you must be logged on the server. You can also use another backup of a database that already contains data, if you have access to such.
+#Download an empty backup file (. Bak) of [ftp://salix.slu.se/Download/Heureka/Databases/ SLU FTP server] and save to your hard disk, for example, C:\TEMP\. If you are installing on a server, the file must be available locally on the server, and you must be logged on the server. You can also use another backup of a database that already contains data, for example the demo database called Heureka_Demo_Mini, also available at the ftp-server.
 # Use alternative 1 or 2 below