A replication definition describes the source table to Replication Server, specifying the columns you want to copy. It may also describe attributes of the destination table. Destination tables that match the specified characteristics can subscribe to the replication definition.
Replication Server provides replication at the database, table, and stored procedure levels. RM allows you to create a replication definition for a database, a table, or a stored procedure. A replication definition for a stored procedure is called a “function replication definition”. You can create, edit, and delete function replication definitions and function subscriptions.
This procedure describes how to create a replication definition for a database.
Creating a replication definition on the primary
database
In the object tree, double-click the database where you want to create a replication definition. The Database Replication Definitions folder displays.
Double-click the Database Replication Definitions folder. The Add New Database Replication Definition window appears.
In the General tab, enter a replication definition name.
You can specify other replication definition settings
on the other given tabs.
Click Replicate all DDL if you want the DDL that is executed at the primary database to be replicated to the replicate database.
Click OK.
