Each replication definition must include the following information:
The name of the replication definition.
The names of the source and destination tables.
Replication Server assumes that the replication definition name is the name of both the source and destination tables, unless you specify differently.
The name of the data server and database where the source table is located.
The column names and datatypes that you want to copy. You can copy all or a subset of the source table’s columns. The replicate column names and datatypes are the same as the primary column names and datatypes, unless you specify differently.
The primary key—one or more columns that uniquely identify each row in the source table.
Optionally, a replication definition may also include:
The names of the owners of the source and destination tables. The default table owner is the Database Owner (dbo).
The names of searchable columns—columns that can be specified in the where clause of a subscription to indicate the rows from the primary table to copy into the destination table.
For a warm standby application, whether to use the replication definition to copy data into a standby database and whether to copy all of the table’s columns or just the columns in the definition’s column list.
Whether to copy only the minimal number of columns required for update and delete operations. This option may enhance overall system performance.
Replication options for text, unitext, image, and rawobject columns.
Column-level datatype translations