Versions Compared

Version Old Version 20 New Version 21
Changes made by

Leslie

Leslie

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

StudyTrax requires SQL Server 2005 or later. If you backup a database and then restore it on a newer version of SQL Server, the compatability level of the earlier version is retained. Thus, the compatability level needs to be updated.

  • Check the compatability level by executing the following in SQL Server Managment Studio: sp_dbcmptlevel 'StudyTrax'
  • A return value of 90 means SQL Server 2005 and 100 means SQL Server 2008.
  • To set the compatability to SQL Server 2008: alter database StudyTrax set compatibility_level = 100
  • To set the compatability to SQL Server 2005: EXEC sp_dbcmptlevel StudyTrax, 90;
Center

Center

Image Removed

If an If the connection string points to an existing installation of StudyTRAX is already installed , an option to patch the database will be shown. It should display the "DB Version" and the "Current" version that the application expects.

...

Note

If these credentials are not available, the manual database patch process must be used

Center

Image RemovedImage Added

After clicking the "Continue" button, a dialog

After clicking the "Continue" button, a loading indicator will appear. The page will refresh and update the "Output" window with what is going on with the patch process every 1 second. Once the process is complete, you should see the word "Finished" at the top of the output window. If this message is not displayed in the output window, check for any errors that may have ocurred.

...