LXR Software Support
How Do I?
Upsize LXR*TEST 6.1 Databases for Use on SQL Server 2000 or
2005
LXR*TEST 6.1 uses the Microsoft Access database engine. Because of this, LXR*TEST
6.1 databases can be upsized (or "converted") to Microsoft SQL Server 7.0, 2000,
or 2005 format.
This documentation on upsizing procedures for SQL Server supplements the User's
Guide Appendix J documentation on upsizing procedures for SQL Server. This documentation
is designed to be a quick reference guide for the upsizing process. You may want
to consult other Access and SQL Server references for further discussion.
Note: LXR*TEST 6.1 incorporates Microsoft JET engine
database technology (LXR*TEST databases are Microsoft Access databases) which is
intended for use by small workgroups. Online LAN or web testing requires scalability
in support of concurrent access of the online testing databases by examinees. LXR*TEST
achieves the necessary scalability by using upsized SQL databases and it’s therefore
assumed that your online testing architecture will include Microsoft SQL Server.
Online testing environments that do not utilize SQL Server are prone to problems
and cannot be supported by LXR. All LXR*TEST databases
can easily be upsized for use with SQL Server.
Prerequisites:
Microsoft SQL Server
Microsoft SQL Server needs to be installed and set up on your server. Contact your
SQL Server Administrator to verify that proper database location(s) and permission(s)
have been set up on the server.
Microsoft Access (Included in Office XP Professional & Enterprise
Editions)
Microsoft Access 2002 needs to be installed on a workstation computer. Also, the
Upsizing Wizard component needs to be installed.
To install the Upsizing Wizard (if not already installed):
- Have an Access database open (create a new database if you don't have an existing
one to open).
- From the Tools menu, choose Database Utilities > Upsizing Wizard.
- You will be prompted to install the Upsizing Wizard from the appropriate CD. Follow
the installation instructions.
How To Process:
Using the Access Upsizing Wizard to Convert Your LXR*TEST
6.1 Database to SQL Server Formatbr />
- Within Access, open the LXR*TEST database (e.g., LXROnline database) you want to
upsize to SQL Server format.
- From the Tools menu, choose Database Utilities > Upsizing Wizard.
- Select Create new database. Click Next.
- Select your SQL Server from the drop-down list.
- Type in your login ID and password.
Note: You will need to verify with your SQL Server
administrator the login procedure you need to follow. For instance, you may (or
may not) need to use a “trusted connection” in order to login.
- Type in a name for the new SQL Server database to be created. Click Next.
- Click the double right direction arrow >> to move all Available Tables to the right
panel (labeled Export to SQL Server). Click Next.
- All table attributes must be selected (i.e., indexes, validation rules, defaults,
and table relationships). Choose the “Use triggers” option, let the upsizing wizard
decide whether to “add timestamp fields to tables”, and leave unselected the option
“Only create the table structure; don’t upsize any data.” Click Next.
- Verify that No application changes is selected. Click Next.
- Click Finish to begin the upsizing process. A report of the upsizing process is
displayed upon completion.
Creating a Data Source Name (DSN) In Order to Interface With
the New SQL Server 2000 Database
Now that your LXR*TEST database has been upsized to SQL Server format, you need
to create a DSN to reference the SQL Server database, located on your server.
- Navigate to Start > Settings > Control Panel > ODBC Data Sources. [In Windows 2000:
Start > Programs > Administration Tools > Data Sources (ODBC).]
- Click on the File DSN tab.
- Click Add. Select the SQL Server driver. If this driver is not listed, then you
need to install the missing ODBC drivers.
- Click Next. Enter a filename to save this DSN. You can accept the default location
in the Data Sources folder, or choose a different location. (Remember the data source
name for later use.) Click Next.
Tip! Choose a DSN name that is suggestive of the nature of the SQL Server database.
This DSN name will display when you click the ODBC button in the Open Database dialog
box within LXR*TEST.
- Review the data source settings and click Finish.
- The Create a New Data Source to SQL Server wizard will ask you for further information.
Type in a brief description if you desire.
- Choose the name of the SQL server where you created the SQL Server database. The
server name appears in the drop-down list box.
- Click Next. Select the authentication method compatible with your SQL server. If
your server is using Integrated Security, then select With Windows NT authentication
using the network login ID. Click Next.
- Check the box for Change the default database to and select the name of the SQL
Server database you created on the server. Leave the other options unchanged. Click
Next.
- Verify that Perform translation for character data is checked. Click Finish.
>li>Within ODBC Microsoft SQL Server Setup click on the Test Data Source button.
If it reports that tests completed successfully, press OK three times to exit.
If you did not get a successful connection to the server, review/repeat the above
steps with your database administrator until you make a successful connection.
Opening the LXR*TEST 6.1 SQL Server formatted database:
- Within LXR*TEST, click on the LXR*TEST Toolbar button that corresponds to the database
type of the SQL Server database, e.g., Online.
- Within the dialog box, click on the ODBC DSN button.
- Log into the SQL server.
- Within the File Data Source tab, select the DSN corresponding to the database you
want to open. Click OK.
Your LXR*TEST 6.1 SQL Server formatted database should open. Congratulations! You
have successfully upsized an Access database to SQL Server.