Overview

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

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. The databases can be running either on separate servers or even on the same server. You will typically use it for back-up purposes (you have two databases with the same content) or in case that you need to spread the load among more databases.

 

Kentico CMS database can be replicated using the merge replication. It can be configured in MS SQL Server Management Studio. The configuration process consists of creating a publication and one or more subscriptions:

 

Publication - the database which has the data to offer to the other server
Subscription - the database which receives updates from the publisher when the data is modified

 

Detailed information about replication in MS SQL can be found at: http://msdn.microsoft.com/en-us/library/ms151198.aspx.

 

 

 

Limitations caused by DB replication!

 

Using database replication with Kentico CMS results in the following limitations:

 

importing is not functional
upgrade from previous versions of Kentico CMS to a higher one is not possible
newly created document types, BizForms and custom tables can not be synchronized to the subscribers
field changes in document types and system tables can not be synchronized to the subscribers
any other additional changes to the database structure are not guaranteed to be synchronized to the subscribers

 

It is therefore recommended to go through the following procedure when your website is complete, i.e. when you won't need to use any of the limited features.

 

In case that you needed to use any of the limited features listed above, you would need to disestablish your existing replication, make the required changes and set up new database replication from scratch.

 

If you want to achieve this manually without disestablishing the existing replication, you can follow the instructions on this page.

 

 

Page url: http://devnet.kentico.com/docs/devguide/index.html?db_replication_overview.htm