Use the create replication definition Command

Use create replication definition to describe to Replication Server the characteristics of a table you want to replicate.

Execute create replication definition at the Replication Server that manages the source table database, or you can use the rs_send_repserver_cmd stored procedure with the create replication definition clause to execute replication definition change requests directly at the primary database.

A replication definition must include the name of the source data server and database.

create replication definition publishers
with primary at TOKYO_DS.pubs2
(pub_id char(4), pub_name varchar(40),
city varchar(20), state char(2))
primary key (pub_id)

See Replication Server Reference Manual > Replication Server Commands > create replication definition for complete command syntax and usage guidelines.

• Specify the Replication Definition Name and Table Names
  A replication definition has a global name space—that is, at every Replication Server with routes from the primary Replication Server, the name refers to the same replication definition.
• Specify Column Names and Datatypes
  When you create a replication definition, list the names and datatypes of the columns from the table that you want to copy.
• Specify the Primary key
  The primary key is the column or combination of columns that uniquely identifies each row.
• Specify Searchable Columns
  Use searchable columns in create replication definition to specify which columns to use in the where clause of create subscription or define subscription (or create article for publications) to restrict the rows copied to a subscribing site.
• Replicate the Minimal Set of Columns
  To enhance replication system performance, specify replicate minimal columns in create replication definition. This clause lets you send only those columns that are required for delete and update operations to replicate databases.
• Use Replication Definitions with Warm Standby Applications
  You do not need to use replication definitions with warm standby applications. However, you can use them to control the flow of information to the standby database—even though no subscriptions are needed.
• Specify text, unitext, and image Column Replication
  There are several requirements if you want to create a replication definition for a table that contains text, unitext, or image columns datatypes.
• Specify Computed Column Replication
  To create a replication definition for a computed columns use the base column datatype in the replication definition for materialized columns. Do not include virtual columns in the replication definition.
• Specify rawobject and rawobject in row Column Replication
  You can include Java columns in a replication definition. Replication Server replicates Java columns as either rawobject or rawobject in row datatypes.
• Specify Column-level Datatype Translations
  You can specify column-level datatype translations in the replication definition.