Use the define subscription Command for Publication Subscriptions

Use define subscription to create a publication subscription and a subscription for each article in the publication.

define subscription always creates a subscription using bulk materialization. Execute define subscription at the Replication Server that manages the destination database. Subscription information is stored in the rs_subscriptions system tables at the source and destination sites.

All subscriptions in the publication subscription are created at the same time.

This example creates a subscription named pubs2_sub for the publication pubs2_pub.

define subscription pubs2_sub 
    for publication pubs2_pub
    with primary at TOKYO_DS.pubs2
    with replicate at SYDNEY_DS.pubs2

When you define a publication subscription with bulk materialization, you can enable replication of truncate table to the destination table.

See Replication Server Reference Manual > Replication Server Commands for complete syntax and usage guidelines.