Use the TMS Database Upgrade

Whenever you install a new version of TMS (a brand new version or an upgrade from an older version to a newer version), you need to run the TMS Database Upgrade on your TMS database, before your users can begin using it with the new version of TMS.

To upgrade your database after upgrading your version of TMS OnSite, follow these steps.

1. After you have installed the new version of TMS OnSite, go toStart > Programs > TMS OnSite > TMS Database Upgrade.

2. The TMS Upgrade Utility screen opens.  Click Next to continue.

3. In the Choose Input Database screen, choose the version of the TMS database you want to upgrade.

   The procedure is the same for upgrading a database from iTMS, TMS Enterprise, TMS Plus, and TMS WorkGroup.

4. Enter the TMS database server in the Server field or select it from the Server drop-down menu.

5. Enter your SQL Server User ID and Password. 

   If you don't already know the user ID and password, your internal system administrator will have to provide you with this information.

   If you are a Windows System Administrator, you can also check the Windows Authentication option, and you will not have to enter a user ID and password.

6. The Database drop-down menu becomes available when you tab or click off the Password field. 

7. Click Next.

   Tthe Time Zone screen opens.

8. Select the time zone where your database server is installed.

   If you have multiple segments outside of this time zone, after you perform the upgrade, you will need to go into the application’s Setup menu (Setup > General > Options) and select the appropriate time zone for each segment.

   Times in the database are stored in Coordinated Universal Time (UTC). For example, if your database is in the Eastern Standard Time zone, your time plus five hours equals Coordinated Universal Time and will be the time stored in the database. Central is plus six hours, Mountain is plus seven hours, and Pacific is plus eight hours.

   The Backup Input Database screen opens.  In addition to your regularly scheduled backups, we recommend you make another backup of your TMS database before you upgrade. 

9. Click the button next to Yes.

10. Select the path on your server where the database will be backed up. 

    This is the path on the server, not on your workstation.  Notice that TMS adds the date and timestamp to the .BAK file. 

    Ex: If the database you want to upgrade is FRSOFTDBPRO201053, when you select the SQL Server Path, TMS changes it to TMSBKUP2006829847AM.bak (TMS backup on August 29, 2006 at 8:47a.m.).

11. Click Next.

12. You can choose the option to List only modified reports or List all Standard Reports.

    Use the check boxes to select those reports you want to copy, or click the Select All button to copy all of the displayed reports. Click Next.

    The Confirmation Screen opens. 

13. Review your selections.

14. Click Previous to go back and make changes to your selections or click Next to perform the upgrade.

    In the Upgrading screen, you can follow the progress of the upgrade. The upgrading process might take over an hour to complete, depending on the size of the database being upgraded. The program might even appear to be frozen at certain points. Allow the utility to complete on its own and do not end the utility with the Task Manager.

    When the upgrade is complete, the confirmation box opens. 

15. Click OK.

16. Click the View Log button to review the TMSDBUpgrade.LOG.

    If you received any error messages during the upgrade, the log file will contain information pertaining to those errors.  If you did receive error messages during the upgrade, contact TMS Technical Support. Our Technical Support analysts need the log files to assist you with any problems with the upgrade. 

17. Click Finish.