LXR Software Support
How Do I?
How Do I Create SQL Server 2008 Databases For Use With LXR*TEST?
This How Do I guide replaces sections 6.8 - 6.11 (p21 - 22) in the
guide to online testing.
You will need download the SQL scripts to create the databases on the server. You
can get the scripts at
ftp://ftp.lxr.com/public/docs/LXR/LXRTEST%206.1%20Databases.zip.
Follow these steps to build the databases on the server
- Unzip the downloaded files to a location of your choosing
- Open SQL Server 2008 Management Studio
- Connect to the desired SQL Server
- Click File > Open > File...
- Browse to the location where the scripts were unzipped
- Select a file and click Open
- Click Query > Specify Values for Template Parameters...
- Type in a name for the database to be created (it is good practice to denote the
type of database in the name. eg: LXRScores or LXRStudents)
- Click OK
- Click Query > Execute
You should now have an empty database. Perform this task with each of the 4 scripts
naming them based on the script name. When you are finished there should be a database
for Online, Scores, Students, and Grading.
Follow the steps in the
guide to online testing in section 6.15 (p28) to create
the DSN connections to the databases.
Once you have created the DSN connections, you will need to open each of the databases
in LXR*TEST 6.1.
You can use the Import feature in the software to import your data from the native
Scores, Students, and Grading databases into the SQL databases. See the User Guide
for instructions on how to do this.
You are now ready to continue with the
guide to online testing at section 6.12 (p24). You will not have to repeat the steps in section 6.15 (p28).