MailSite Knowledge Base

Enter text to search for or enter the document ID number.
Search:   
Doc ID:   

Refreshing/Updating SQL Tables and Stored Procedures
Document #:10097

Applies To:
  • MailSite All

Synopsis:
When upgrading, customers that run MailSite in the SQL Connector must manually update the stored procedures and tables. This can be done via the MailSite Console or via SQL Server.

More Information:

This can be done either piror to the upgrade directly in SQL server by your DBA or after the new version of MailSite has been installed. After the upgrade has been completed, the Configuration Connector wizard should again be run (double click on SQL Connector). When the option to refresh the stored procedures and tables appears, tick the boxes “Refresh the stored procedures” and “Refresh the tables”. This will ensure the latest information is now stored in the MailSite database.

To update via SQL Server, load Query Analyzer:

  • Select the database you are using for MailSite
  • Load the file tables.sql (This must be done first)
  • Run this file
  • Load the file procedures.sql
  • Run this file
  • Quit Query Analyzer and restart the MailSite services.

Note: It is not necessary to run dcconversion.sql.

The tables.sql and procedures.sql can be found within the MailSite installation folder, or on the MailSite download page.

Related:
See these other knowledge base documents:
Last revised 2010-2-4
 
 

MailSite SE - Easy email and calendar server software for small businesses | MailSite ExpressPro - AJAX email and calendar client for web browsers
MailSite Fusion SP - Scalable and clustered email and calendar hosting software | Email Server and Calendar Server Software
MailSite Mobile Sync Server | MailSite Calendar Server Software | MailSite Anti-Virus | Mailsite Anti-Spam | Customer Portal
Support | Webstore | Services | Partners | Press | Company | Contact | Reviews | Site Map | Privacy | ©2010 MailSite, Inc.
BlackBerry® is a registered trademark of Research in Motion Limited. Outlook®, Windows Vista® and ActiveSync® are registered trademarks of Microsoft Corporation. MailSite Inc. is in No Way Affiliated with Research in Motion Limited or Microsoft Corporation.