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, forms and custom tables can't be synchronized to the subscribers
•field changes in document types and system tables can't 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.