Subscriptions

Sort order and character sets must be consistent everywhere for subscriptions to be valid.

• Subscription Materialization
  Materialization is creating and activating subscriptions, and copying data from the primary database to the replicate database, thereby initializing the replicate database.
• Subscription Resolution
  Subscriptions pass through phases before they are fully set up in your replication system.
• Subscription Reconciliation
  Subcription reconciliation is for recovering inconsistency in a replicate table and correcting the discrepancies.
• Dematerialization
  Dematerialization is when you execute a command to drop subscriptions at the replicate Replication Server.