Enabling replication

To mark a table for replication, log in to the Adaptive Server managing the database for that table and enter:

sp_setreptable table_name, 'true'

Marking the table in this way specifies that the table name must be unique.

NoteDo not mark a table for replication unless you also create a replication definition for the table in the Replication Server managing that database. The RepAgent will begin forwarding to the Replication Server data for transactions for the affected table. If a replication definition does not exist, Replication Server may report message 32032 and its error log file may fill up. In addition, Replication Server performance may be significantly reduced. Warm standby applications, which do not require replication definitions, are not subject to this problem.