These scripts create replication definitions for the salesdetail table at each primary site:
-- Execute this script at Chicago RSCHI.
-- Creates replication definition chi_sales.
create replication definition chi_sales_rep
with primary at DSCHI.DBCHI
with all tables named 'salesdetail'
(stor_id char(4),
ord_num varchar(20),
title_id varchar6),
qty smallint,
discount float)
primary key (stor_id, ord_num)
searchable columns
(stor_id, ord_num, title_id)
go
/* end of script */
-- Execute this script at New York RSNY.
-- Creates replication definition ny_sales.
create replication definition ny_sales_rep
with primary at DSNY.DBNY
with all tables named 'salesdetail'
(stor_id char(4),
ord_num varchar(20),
title_id varchar6),
qty smallint,
discount float)
primary key (stor_id, ord_num)
searchable columns
(stor_id, ord_num, title_id)
go
/* end of script */
-- Execute this script at San Francisco RSSF.
-- Creates replication definition sf_sales.
create replication definition sf_sales_rep
with primary at DSSF.DBSF
with all tables named 'salesdetail'
(stor_id char(4),
ord_num varchar(20),
title_id varchar6),
qty smallint,
discount float)
primary key (stor_id, ord_num)
searchable columns
(stor_id, ord_num, title_id)
go
/* end of script */
