|
Replied on
13 Aug 2013 10:29 PM IST
SQL Server Replication Overview
You can use SQL Server replication to synchronize Sitecore databases in multiple locations. For example, you can use SQL Server replication to synchronize the Master database between multiple Content Management (CM) environments.
1 Distributor A distributor is a database server responsible for synchronizing data using SQL Server replication, managing publications and subscriptions. SQL Server uses a distribution database to manage replication.
2 Publication A publication is a database to synchronize using SQL Server replication. Select a database in one environment as the publication database. The corresponding database(s) in other environments will function as subscriptions.
3 Subscriptions A subscription is a database to synchronize using SQL Server replication.
Because any environment can initiate data changes in a replicated database, the publication database functions as a subscription database.
You can use any of the techniques described in the following sections to create subscriber databases from the publication database.
Initialize Subscriptions with a Database Backup To initialize a subscriber with a database backup: - Disable write access to the publication database.
- Archive the publication database.
- Restore the database to replicate to as one or more subscribers.
- Configure SQL Server replication as described in this document.
- Enable write access to the publication and subscriber databases.
Initialize Subscriptions with a Snapshot Using a Network Share To initialize a subscriber with a snapshot, when you are configuring SQL Server replication as described in this document, do the following: - Make sure that the EventQueue table on the publication server is empty. To do this, execute the following SQL command: delete from EventQueue. Otherwise you may experience problems with the initialization timestamp columns in the subscriber tables.
- In the New Publication Wizard, in the Snapshot Agent window, select the Create a snapshot immediately and keep the snapshot available to initialize subscriptions check box.
For more information about the New Publication Wizard, see the section Publication Configuration.
Initialize Subscriptions with SQL Server Integration Services You can initialize a subscriber by copying the publication database using SQL Server Integration Services.
4 Replication Modes that Sitecore CMS Supports Sitecore CMS supports Merge replication mode for Sitecore content databases.
Sitecore does not support Transactional and Snapshot replication modes due to technical limitations in conflict resolution, database schema requirements, and synchronization frequency associated with these modes. Sitecore has not tested Transactional and Snapshot replication modes and use of these modes may lead to unexpected behavior in regards to data and cache consistency.
Sitecore CMS does not support replication of the Analytics database in any way.
|