Using bulk materialization

This script defines, activates, and validates a subscription at the replicate Replication Server for the replication definition defined at the primary Replication Server.

-- Execute this script at Sydney Replication Server
 -- Creates subscription using bulk materialization
        for upd_publishers_pubs2
 define subscription upd_publishers_pubs2_sub
 for upd_publishers_pubs2
 with replicate at SYDNEY_DS.pubs2
 go

activate subscription upd_publishers_pubs2_sub
 for upd_publishers_pubs2
 with replicate at SYDNEY_DS.pubs2
 go
 /* Load data. If updates are in progress,use activate
subscription with the “with suspension” clause and
resume connection after the load. */

validate subscription upd_publishers_pubs2_sub
 for upd_publishers_pubs2
 with replicate at SYDNEY_DS.pubs2
 go
 /* end of script */