The reference implementation toolset creates stored procedure, replication definition, subscription, and table objects in the reference replication environment.
Stored procedure |
Location |
|---|---|
sp_load_warehouse_data |
Primary and replicate databases |
sp_load_district_data |
Primary and replicate databases |
sp_load_customer_data |
Primary and replicate databases |
sp_load_history_data |
Primary and replicate databases |
sp_load_item_data |
Primary and replicate databases |
sp_load_stock_data |
Primary and replicate databases |
sp_load_order_orderline_data |
Primary and replicate databases |
sp_load_neworder_data |
Primary and replicate databases |
sp_load_data_multi_tran |
Primary and replicate databases |
sp_gen_neworder_data |
Primary database |
sp_gen_payment_data |
Primary database |
sp_gen_delivery_data |
Primary database |
sp_gen_neworder_data_large_tran |
Primary database |
sp_gen_payment_data_large_tran |
Primary database |
sp_gen_delivery_data_large_tran |
Primary database |
sp_generator_data_1 |
Primary database |
sp_generator_data_2 |
Primary database |
sp_generator_data_3 |
Primary database |
sp_generator_data_4 |
Primary database |
Stored procedure |
Subscribing for |
|---|---|
Replication definition: pdbrepdefforrdb |
|
Subscription: rdbsubforpdb |
pdbrepdefforrdb |
Table |
Location |
|---|---|
WAREHOUSE |
Primary and replicate databases |
DISTRICT |
Primary and replicate databases |
CUSTOMER |
Primary and replicate databases |
HISTORY |
Primary and replicate databases |
NEW_ORDER |
Primary and replicate databases |
ORDER |
Primary and replicate databases |
ORDER_LINE |
Primary and replicate databases |
ITEM |
Primary and replicate databases |
Stock |
Primary and replicate databases |