Difference between revisions of "Installation"

From dbscript Online Help
Jump to: navigation, search
(IIS Server)
(Server Requirements)
Line 5: Line 5:
 
* [http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=11121 MS Ajax Control Toolkit]
 
* [http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=11121 MS Ajax Control Toolkit]
 
* SQL Server 2000 or higher
 
* SQL Server 2000 or higher
 +
* ODP.Net from [http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html Oracle Data Access Components 11g] (only if Oracle functionality is required)
  
 
== Installation ==
 
== Installation ==

Revision as of 22:20, 10 June 2009

Server Requirements

Installation

SQL Server

Open Enterprise Manager (SQL 2000) or SQL Management Studio (SQL 2005+)

  • Create a database
  • In the database, run the scripts:
  • Create.sql
  • Initialize Users.sql
  • Value Script.sql
  • Code Snippet.sql

(The names of the sql scripts are preceded by "dbs" plus the version number)

The Users table contains one record with the ID "Administrator". You can change the ID to your desired username to log in to the application.

SQL Server must allow SQL Server authorization.

Create a database login:

  • SQL Server authorization
  • no password policy
  • allow dbo access to the database.

IIS Server

  • Create a directory, virtual directory, or website in IIS Administrator
  • Extract web.zip into the directory
  • Copy web.config into the directory
  • Locate the connection string in web.config and adjust server name, catalog, username, and password.

The web.zip filename is preceded by "dbs" + date + version.

Upgrade

SQL Server

Open Enterprise Manager (SQL 2000) or SQL Management Studio (SQL 2005+) and locate the existing dbscript database.

  • Open a query window in the database and run the scripts
  • database upgrade script named "dbs" + new version + "from" + old version + ".sql"
  • Value Script.sql
  • Code Snippet.sql

IIS Server

Extract the contents of web.zip into the web application directory.

The web.zip filename is preceded by "dbs" + date + version.

Register License

  • Start your webbrowser and navigate to the URL of your installation
  • Login using the selected username without password
  • Navigate to Settings, upload you license key file