How to manually upgrade the MessageStats database to the latest version on both "clustered" and "non-clustered" SQL 2005, SQL 2008 and SQL 2012, 2014, 2016 Servers.
Note: The migration script (MessageStatsMigration.sql) is included with the MessageStats software that can be downloaded from the Support Portal https://support.quest.com/messagestats
Please copy the MessageStats Migration Script (MessageStatsMigration.sql) from the SQL folder included with the MessageStats download.
IMPORTANT NOTES:
- These steps are known to work successfully; however, they have not been officially tested by Quest Quality Control.
- If any of these instructions are changed, this solution becomes unsupported by Quest Support and Development. For customization of the Quest MessageStats product, please contact our Professional Services Organization
NOTE: Make sure no gathering tasks are running when upgrading the MessageStats Database.
To upgrade to the database to the latest version manually:
1. Launch SQL Server Management Studio.
2. Connect to the SQL Server that is hosting the MessageStats Database (for example, Server Type = Database Engine, Server Name = SQL Server Name and Authentication = either Windows Authentication or SQL Server Authentication.
3. Expand SQL Server Name.
4. Expand Databases.
5. Copy the MessageStatsMigration.sql SQL Script to the SQL Server where the MessageStats database resides.
6. Right click the MessageStats Database and select New Query.
7. After the Query window opens, select the File | Open | File.
8. Locate the SQL Script that was downloaded from this solution and open it.
9. Provide either Windows Authentication or SQL Server Authentication, click Connect.
10. Select the Query Menu and then Execute. (Select the MessageStats Database)
11. This should migrate all the tables and roles required.
12. Go to the Security\Logins folder in SQL Management Studio.
13. Confirm that the MessageStats Admin login has the following for database access: public, db_Owner and MessageStats_Admin.
14. Confirm that the MessageStats Web login has the following for database access: public and MessageStats_Web.
15. Close SQL Management Studio.
16. Upgrade the MessageStats Scheduler (Console) and Web reports to the latest version.
Browse to where you extracted the MessageStats Installation Package and run Setup.exe using the MessageStats service acccount. Select Custom Install and do not select the Database portion
17. Confirm that the MessageStats Console will connect by launching and confirming all settings.
