Subscriptions

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 */