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