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: