How do I create the database for a new installation?

Topics: General '15
Nov 19, 2013 at 9:16 PM
First time user trying to set this up. I can't seem to find installation instructions for the latest release (2.1) so working off of the manual installation instructions for 2.0 located here.

That says to run "SurveyProject_2.0_NewDBInstall.sql" only there isn't one in the _DatabaseSQL directory. Am I looking in the wrong place?

--sages
Coordinator
Nov 19, 2013 at 9:52 PM
Edited Nov 19, 2013 at 9:53 PM
"Existing DB installation"
  • start MS SQL Server (using Enterprise Manager or your tool of choice )**
  • create a new empty database
    a. in case Sqlserver 2012:
  • open sql file SurveyProject_2.1_Final_ExistingDBInstall.sql' from the '_Sql' website directory in a query window
    b. in case of Sqlserver 2008
  • open sql file SurveyProject_2.1_Final_ExistingDBInstall_Mssql2008.sql' from the '_Sql' website directory in a query window
  • change USE [yourdatabasename] command to the name of your database
  • run sql query
  • check to see if database was created correctly