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