The included sample database called QO_SHOP, and the SQL script files are available under the {install folder}\NET20\Samples\Database.
Two sets of script files are available. One set of Oracle 9i or later database and the other is for SQL Server 2005.
- {Database Prefix} Create Tables.sql - Create Tables can be used if you wish to manually create the database. By default the installer will give the user choice of configuring the sample database automatically on a SQL Server 2005 server (including express edition).
- {Database Prefix} Drop Tables.sql - If you like to recreate the sample QO_SHOP database or drop it all together this script file can be used.
- {Database Prefix} Insert Data.sql - If you are recreating the sample database and would like to insert the default test data, you can use this script.
A "SQL 2005 ReCreate Database.bat" file is also included for your convenience and this file can be used to re-create the sample tables in the QO_SHOP at anytime. Please note this batch files assumes that SQL Server Express edition was installed at the default path so if that is not the case you can edit the file with appropriate settings. Also, the script assumes that there is a database called QO_SHOP in the SQL Server.
Click to enlarge
The included samples can run with Oracle database as well, please change the connection string to point to the instance of QO_SHOP database.