Each site has a subscription to the replication definitions at the other two sites. These scripts create the subscriptions:
-- Execute this script at Chicago RSCHI.
-- Creates subscriptions to ny_sales and sf_sales.
create subscription ny_sales_sub
for ny_sales_rep
with replicate at DSCHI.DBCHI
where stor_id = '5023'
go
create subscription sf_sales_sub
for sf_sales_rep
with replicate at DSCHI.DBCHI
where stor_id = '8042'
go
/* end of script */
-- Execute this script at New York RSNY.
-- Create subscriptions to chi_sales and sf_sales.
create subscription chi_sales_sub
for chi_sales_sub
with replicate at DSNY.DBNY
where stor_id = '7067'
go
create subscription sf_sales_sub
for sf_sales_rep
with replicate at DSNY.DBNY
where stor_id = '8042'
go
/* end of script */
-- Execute this script at San Francisco RSSF.
-- Creates subscriptions to chi_sales and ny_sales.
create subscription chi_sales_sub
for chi_sales_rep
with replicate at DSSF.DBSF
where stor_id = '7067'
go
create subscription ny_sales_sub
for ny_sales_rep
with replicate at DSSF.DBSF
where stor_id = '5023'
go
/* end of script */
