Kentico CMS 7.0 On-line Marketing Guide

Overview

Overview

Previous topic Next topic Mail us feedback on this topic!  

Overview

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

When using contact management on high‑traffic websites, the system will need to store a very large volume of data in order to keep records of all contacts, their activities and other related information. This may complicate database administration and make it difficult to perform regular backups. For these reasons, Kentico CMS provides a way to move all tables and database objects associated with contact management to a separate database (including the currently stored data). Doing so allows easier management of the application's main database, without the need to deal with the contact data.

 

Please note that there can only be one separated contact management database for the entire system, even when hosting multiple websites. It is not possible to create a different database for each site.

 

The steps needed to perform the database separation are described in the Separating the contact management database topic. If you wish to reverse the process and return everything back to a single database, you can do so by following the instructions in Rejoining the databases.

 

The separation procedure affects the following database tables:

 

OM_Account

OM_AccountContact

OM_AccountStatus

OM_Activity

OM_ActivityType

OM_Contact

OM_ContactGroup

OM_ContactGroupMember

OM_ContactRole

OM_ContactStatus

OM_IP

OM_Membership

OM_PageVisit

OM_Rule

OM_Score

OM_ScoreContactRule

OM_Search

OM_UserAgent

Newsletter_Link

Newsletter_OpenedEmail

Newsletter_SubscriberLink

 

Refer to the database information in the Internals and API chapter to learn more about specific tables.