Take these steps to speed up the upgrade process dramatically and to prevent the bloating of the database log file. Otherwise, the process might go very, very slowly.
Note: Some of these instructions apply only to Time Matters 13 and older.
Consult with your Time Matters Consultant before considering these speed-up tips.
Depending on the size of your old Time Matters database and the speed of your machine, conversion to a new version could take up to 18 hours or longer without these performance tweaks.
Disable Keyword Indexing in the previous version and run Database Maintenance.
With approval from your IT specialist, use SQL Server Management Studio to change the Recovery Model of the Time Matters database to Simple.
Increase the initial size of the TM database.
Heads Up - You could do serious damage to your database with SQL Server Management Studio. If you are unsure about making changes, please consult with a LexisNexis Certified Independent Consultant or Technical Support. Don't hesitate to call us at 800.575.0007. Back up your database before making any changes.
Instructions for Disabling Keyword Indexing.
Versions of Time Matters running on MS SQL Server or MS SQL Server Express do not need Keyword Indexing. SQL Server builds indexes as needed on the fly for the efficient retrieval of records.
The Keyword Index in Time Matters can dramatically increase the time needed to import data into a new version.
To disable Keyword Indexing in your old version of Time Matters before importing into a new version:
Backup your old Time Matters database
Open the old Time Matters database
Go to: Main Menu | File | Setup | General | Program Level
Click on Update
Click on No Fields will be Keyword Indexed
Backup Time Matters: Main Menu | File | Backup Time Matters Data
Go to: Main Menu | File | Utilities | Database Maintenance
Uncheck all the boxes except: Update Keyword Index
Click OK - Note: This process may run through each of the data tables, but it will do so faster than a typical Database Maintenance process.
Technical Note: The Keyword table may still have records in it that are used in connection with Time Matters for MS Outlook.
Instructions for Changing the Time Matters Recovery Model
After installing Time Matters 13.1 on the server or your main computer and before starting the data import from the previous Time Matters version, follow these steps:
Open SQL Server Management Studio
Click on [+] next to Databases
Right-click on TimeMatters13
Click on Bulk-logged and switch it to Simple
Click OK and close SQL Server Management Studio
Instructions for Increasing the Initial Size of the TM 13.1 Database
Open SQL Server Management Studio.
Click on [+] next to Databases.
Right-click on TimeMatters13.
In the Initial Size column, click on the number in the first row (not the Log row).
Enter a number equal to the size of your old Time Matters database.
To determine the size of your old database, check the size of your recent SQL backup file (a .BAK file) or check the Files page of the Properties for your old database in SQL Server Management Studio.
Make the Properties window wider by clicking and dragging the right border to the right.
Click in the Autogrowth column on the button [...] in the first row (not the Log row)
Click the In Percent option and leave it on 10%.
Click OK, OK, and close SQL Server Management Studio
A tip of the hat to Ken Kennedy, CIC, of Circle Management Group for this tip on increasing the database size.