Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: repsequences_prod3
-- Features: Creates sequences for all replicated tables for the master
site prod3.
-- NOTE: This script should only be run on the master site prod3.
-- Each master site has sequence starting values which are different
in order to avoid
-- primary key conflicts when replicating data between sites.
-- Copyright 2002 by .com Solutions Inc.
-- This output file was created by Repgen version 2.2.4 on Fri May 31
13:29:24 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
-- ************** customer_repgroup
DROP SEQUENCE WIDGETS1.CUSTOMERS_SEQ;
CREATE SEQUENCE WIDGETS1.CUSTOMERS_SEQ
START WITH 1000000000
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
NOCYCLE
CACHE 20
ORDER;
DROP SEQUENCE WIDGETS1.ADDRESSES_SEQ;
CREATE SEQUENCE WIDGETS1.ADDRESSES_SEQ
START WITH 1000000000
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
NOCYCLE
CACHE 20
ORDER;
-- ************** static_tables_repgroup
DROP SEQUENCE WIDGETS1.STATE_PROVINCE_SEQ;
CREATE SEQUENCE WIDGETS1.STATE_PROVINCE_SEQ
START WITH 1000000000
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
NOCYCLE
CACHE 20
ORDER;
DROP SEQUENCE WIDGETS1.COUNTRY_SEQ;
CREATE SEQUENCE WIDGETS1.COUNTRY_SEQ
START WITH 1000000000
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
NOCYCLE
CACHE 20
ORDER;
