The headquarters site has subscriptions to the replication definitions at each of the three primary sites. The primary sites have no subscriptions. This script creates the subscriptions in the RSHQ Replication Server:
-- Execute this script at Headquarters RSHQ.
-- Creates subscriptions to chi_sales, ny_sales,
-- and sf_sales.
create subscription chi_sales_sub
for chi_sales_rep
with replicate at DSHQ.DBHQ
where stor_id = '7067'
go
create subscription ny_sales_sub
for ny_sales_rep
with replicate at DSHQ.DBHQ
where stor_id = '5023'
go
create subscription sf_sales_sub
for sf_sales_rep
with replicate at DSHQ.DBHQ
where stor_id = '8042'
go
/* end of script */
