Schema design for Enterprise Replication
When you design the database and tables for replication, you must follow the requirements and restrictions for Enterprise Replication.
- Unbuffered Logging
- Table Types
Enterprise Replication has restrictions on the types of tables that can participate in replication. - Label-based access control
You cannot apply label-based access control (LBAC) to a table participating in Enterprise Replication. Nor can you define an Enterprise Replication replicate on a table that is protected by LBAC. - Out-of-Row Data
- Shadow columns
Shadow columns are hidden columns on replicated tables that contain values that are supplied by the database server. The database server uses shadow columns to perform internal operations. - Unique key for replication
All tables that are replicated must have a replication key that is composed of one or more columns that uniquely identifies each row. The replication key must be the same on all servers that participate in the replicate. Typically, the replication key is a primary key constraint. - Cascading Deletes
If a table includes a cascading delete, when a parent row is deleted, the children are also deleted. If both the parent and child tables participate in replication, the deletes for both the parent and child are replicated to the target servers. - Triggers
A trigger is a database object that automatically sets off a specified set of SQL statements when a specified event occurs. - Constraint and replication
When you use constraints, ensure that the constraints you add at the target server are not more restrictive than the constraints at the source server. Discrepancies between constraints at the source and target servers can cause some rows to fail to be replicated. - Sequence Objects
- The NLSCASE database property
Enterprise Replication supports both case-sensitive databases and NLSCASE INSENSITIVE databases. (Databases created with the NLSCASE INSENSITIVE option ignore letter case in operations on NCHAR and NVARCHAR strings, and on strings of other character data types that are cast explicitly or implicitly to NCHAR or NVARCHAR data types.) - Replicating Table Hierarchies
To replicate tables that form a hierarchy, you must define a separate replicate for each table. - Replication and data types
Enterprise Replication supports built-in data types and user-defined data types, including row types and collection types.
Parent topic: Planning and designing for Enterprise Replication