IMPORTANT NOTES:
- These steps are known to work successfully; however, they have not been officially tested by Quest Software Quality Control.
- If any of these instructions are changed, this solution becomes unsupported by Quest Support and Development. For customization of the Quest Spotlight on Messaging product, please contact our Professional Services Organization:http://www.quest.com/professional-services.
The steps to manually upgrade the SoM database can be found in more detail on page 19 of theSpotlight on Messaging Deployment Guide
Thesesteps are also outlined below:
To manually upgrade the Spotlight on Messaging 7.4.1 database:
1. Obtain the Spotlight on Messaging 7.4 to 7.4.1 Upgrade Scripts which can be found withthe installation files of the product in a subfolder called DatabaseScripts. These files can also be accessed by running the autorun utility of the installer and selecting Install | Spotlight on Messaging Manual Database Scripts
2. Open the UpgradeScripts folder and then the 74_to_741 subfolder.
3. Open Microsoft SQL server Management Studio (or similar application to open SQL scripts)
4. Click File | Open | File
5. Open UpgradeSchema2.sql
6. Select Query | Execute
7. Repeat steps4 through 6to install also the following SQL script file:
* UpgradeData.sql
(SpotlightManagementFramework database is upgraded)