MailSite Fusion - Knowledge Base

MailSite Fusion is a mail server, calendar server and contact server that works with Outlook 2007, iPhone, Windows Mobile and BlackBerry smartphones and provides a low cost alternative to Microsoft Exchange Server

Support Forum Knowledge Base Contacts Open Case Emergency

MailSite Knowledge Base

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

Refreshing/Updating SQL Tables and Stored Procedures

Document #:10097

Applies To:

MailSite All

Synopsis:

When upgrading MailSite customers who 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:

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
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.

See these other knowledge base documents:

Last revised 2008-7-1