+1 408 879 5600 (USA) +44 (0) 113 383 0125 (UK)

• MailSite All

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.

This can be done either prior 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. The tables.sql and procedures.sql files are located in the default installation folder for MailSite.

With the release of MailSite 9.5, support for Microsoft SQL Server 2000 has been removed from the standard SQL procedures. Customers running SQL server 2000 should download the MailSite SQL 2000 Tables and Procedures Upgrade Scripts , apply these to 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.

See these other knowledge base documents:

• 10098:Migrating from registry to SQL connector fails
  
• 10110:Updating your V.4 Datacenter DB to MailSite SP V.5 DB
  
• 10131:Common pitfalls when installing MailSite SP-C
  

Last revised 2011-7-22