Upsizing a Database to SQL Server

IMPORTANT: Mouse Tracks will only operate with SQL Server with an Enterprise Registration Key.

If you purchased the Enterprise Edition of Mouse Tracks, you have the option of upsizing your Database to SQL Server. Doing so eliminates the corruption issues associated with large Microsoft Access databases, speeds up performance across WAN connections, and provides a highly scalable database.

Step-by-step Instructions

Step 1 - Launch Microsoft Access

IMPORTANT: You must use a copy of Microsoft Access XP, 2003 or 2007 to run the Upsize Wizard (DO NOT USE the Access 97 or 2000 upsizing tools).

Step 2 - Open the mtrackbe.mdb file using the following method

  1. Under the Open a File section, choose More Files... (even if mtrackbe.mdb is listed as a recently used database).
  2. Browse to the location of your MTrackbe.mdb file and highlight it (do not double-click).
  3. From the Open command drop down list, choose Open Exclusive. If you are unable to open this exclusively, make sure other users have exited Mouse Tracks and then try this again.

Step 3 - Upsizing the Database

  1.  From the Tools Menu, choose Database Utilities--Upsizing Wizard.
  2.  Select the Create New Database Option.
  3.  Click Next.
  4.  Type in the name or IP Address of your SQL Server Database Server.
  5.  Uncheck the Use Trusted Connection option.
  6.  Enter an Administrative Logon ID and Password for the SQL Database Server.
  7.  Enter the name of the database you wish to create (e.g., mtracks).
  8.  Click Next.
  9.  Click the >> command to have all tables exported.
  10.  Click Next.
  11.  Select Indexes, Validation Rules, Defaults, and Table Relationships.
  12.  For the Table Relationships option, choose Use triggers.
  13.  From the Time Stamp Option, choose 'No, Never'.
  14.  Make sure that the 'Create Table Structure Only' option is unchecked.
  15.  Click Next.
  16.  Select the No Application changes option.
  17.  Click Next.
  18.  Click Finish.

Step 4 - Renaming the MtrackBE.mdb file

Close Microsoft Access and then rename the mtrackbe.mdb file to mtrackbe.old

The next time you start Mouse Tracks you will receive a start up error stating that it couldn't find the database.  From the connection wizard form, choose 'Connect to an Existing Database' and then follow the SQL Server path through the wizards.

If you have configured the IIS Help Desk Interface Add-on you will need to update the mt_init.inc file on your IIS server to point to your new SQL server database.

Tip

You can force the Mouse Tracks Windows Client to prompt you for a new database connection by holding down the shift key while launching the program.


Created using Helpmatic Pro HTML