These scripts create table replication definitions for the publishers table at the primary Replication Server. Each replication definition describes a different view of the primary table.
-- Execute this script at Tokyo Replication Server
-- Creates replication definitions pubs_rep and
pubs_copy_rep
create replication definition pubs_rep
with primary at TOKYO_DS.pubs2
with all tables named 'publishers'
(pub_id char(4),
pub_name varchar(40)
city varchar(20)
state varchar(2)
primary key (pub_id)
go
create replication definition pubs_copy_rep
with primary at TOKYO_DS.pubs2
with primary table named 'publishers'
with replicate table named 'pubs_copy'
(pub_id char(4),
pub_name varchar(40)
primary key (pub_id)
go
/* end of script */
