Subscriptions

These scripts create subscriptions for the replication definitions defined at the primary Replication Server.

-- Execute this script at Sydney Replication Server
 -- Creates subscription pubs_sub and pubs_copy_rep
 Create subscription pubs_sub
 for pubs_rep 
 with replicate at SYDNEY_DS.pubs2
 go
 
 create subscription pubs_copy_sub
 for pubs_copy_rep
 with replicate at SYDNEY_DS.pubs2
 go
 /* end of script */

-- Execute this script at Seattle Replication Server
 -- Creates subscription pubs_copy_sub
 create subscription pubs_copy_sub
 for publ_copy_rep
 with replicate at SEATTLE_DS.pubs2
 where pub_id >= 1000
 go
 /* end of script */