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
Important Information ==========
Important Information
What changes have been made to the SQL Tables and SQL Stored Procedures between MailSite SP v8.0.1 and v9.0.
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 |