Replicate timestamp Columns

Replication Server supports timestamp as a Replication Server datatype.

timestamp is defined as varbinary(8) with a status bit indicator that differentiates it from varbinary. This allows the replication of timestamp columns to replicate, standby, and MSA databases.

You can also define timestamp as a primary key in a replication definition, and a searchable column in a replication definition and a function replication definition.

The send_timestamp_to_standby configuration parameter is also added to support timestamp replication. When send_timestamp_to_standby is enabled and there are no replication definitions, timestamp columns are sent to the replicate database.

For any table containing timestamp column, the maintenance user must be the owner of the table or must be the “dbo” user of aliased to the “dbo” login name at the replicate database.

• Specify a timestamp Column in a Replication Definition
  To create a replication definition for a table that contains a timestamp column, specify timestamp as the declared datatype for the column or use a column-level translation to specify timestamp as the published datatype for the column.