Creating Logical Primary Replication Paths

Use the add and logical parameters with sp_replication_path to create logical primary replication paths that you can use to distribute data and objects bound to a physical path to multiple Replication Servers.

Prerequisites

Create the relevant physical primary replication paths to support the logical primary replication paths.

Task

If you bind a replication object such as the dt1 dimension table to pdb_1, dt1 always travels through pdb_1 to RS2. Using the example replication system and the three physical primary replication paths—default, pdb_1, and pdb_2, you can create a logical replication path named logical_1 to distribute dt1 through pdb_2 to RS2.

Note: You cannot add the default path to a logical path.

Create the logical_1 logical path and add pdb_1 as a physical primary replication path:
At PDS, enter:
```
sp_replication_path 'pdb', 'add', 'logical', 'logical_1', 'pdb_1'
```
logical_1 sends data through pdb_1 to RS1 only.
Add pdb_2 as a physical primary replication path for logical_1:
At PDS, enter:
```
sp_replication_path 'pdb, 'add', 'logical', 'logical_1', 'pdb_2'
```
logical_1 sends data through pdb_1 to RS1 and pdb_2 to RS2.

Dropping Elements in a Logical Primary Replication Path
Use the drop and logical parameters with sp_replication_path to remove elements from a logical replication path.
Removing a Logical Path
Use the drop and logical parameters with sp_replication_path to remove an entire logical replication path.

Parent topic: Multiple Primary Replication Paths