create subscription Command

Use the create subscription command to replicate data by subscribing to a replication definition.

You can use a where clause to replicate only certain rows from the primary table, based on values for the searchable columns specified in the table replication definition. If you do not provide a where clause, all rows are replicated.

If you are using Adaptive Server Enterprise version 11.5 or later, you can include the subscribe to truncate table keywords to reproduce execution of the truncate table command at the destination database.

See Replication Server Reference Manual > Replication Server Commands > create subscription.

• Use create subscription command for Atomic Materialization
  Use create subscription to enable atomic materialization.
• Use create subscription command for Nonatomic Materialization
  Use create subscription with the without holdlock clause to create a subscription with nonatomic materialization.
• Use create subscription command for Direct Load Materialization
  Use create subscription with the direct_load option to create a subscription with direct load materialization.
• Use create subscription command for No Materialization
  Execute create subscription with the without materialization clause at the Replication Server managing the replicate database to create a subscription that does not initialize the subscription data.