SQL Connector Database Changes between 8.0.1 and 9

Document ID: 10492

Synopsis

What changes have been made to the SQL Tables and SQL Stored Procedures between MailSite SP v8.0.1 and v9.0.

More Information

SQL Connector Database Changes between 8.0.1 and 9

What changes have been made to the SQL Tables and SQL Stored Procedures between MailSite SP v8.0.1 and v9.0.

Important Information ==========

Important Information
=====================

Below are the changes which have been made to the Stored procedures for MailSite.  The changes marked in Blue are additions, Red are removals and Grey is for items that have not changed but makes the changes more readable. Before installing the updates please review the changes.  These changes will not cause any service issues if the procedure is not updated.

Tables.sql Changes

Tables Affected New Columns/Details
DomainProperties AirSyncRemit
MailboxProperties AlternativeSender
EnabledAirSync
MailboxProperties2 Newly created table
MailboxPropertyTypes Newly created table

Procedures.sql Changes

Procedure Affected New properties/Details
RegisterMailboxProperty New procedure
SetMailboxIdProperty2 New procedure
GetMailboxIdProperty2 New procedure