Adding and configuring the empty demonstration databases to the SQL Server

Parent Previous Next
  Qsoar Installation And Configuration Guide ›› Installation ›› Test and Demonstration sites (for internal use only) ›› Install SQL 2008 Express and databases ›› Adding and configuring the empty demonstration databases to the SQL Server

Prerequisites


An SQL Server needs to have been installed before this step.


Installation of empty demonstration databases


Down load the appropriate demo_dbs zip file from the Quoxient web site dowload page in the Config Area.  ( http://quoxient.com.au/qsoar_download.html )




Create a short path name from the root of your c:drive, called install (c:\install).  The folder name should contain no spaces and be under 8 charters in length.  Unzip[ the contents of  demo_dbs  zip file into this folder.  You should have a folder C:\install\CreateDBs, with a number of files in the CreateDBs folder.  Navigate to the CreateDBs folder.



Right mouse click on 'create_all_*_dbs.cmd'  (Where the * matches the demo sites downloaded).



And click 'Run as administrator'.




Press 'Y' and 'Enter' as we have set up an SQLEXPRESS instance earlier in Basic installation of SQL Server (2008) Express.




Press any key (ok the 'space bar' if you can't find the 'any' key), and the databases should now be installed.


The CreateDemoDBs folder is not longer required.  You may want to keep it around as it contains a sub-folder that will allow you to run scripts to reset specific databases back to empty.