Function replication definition commands

A function replication definition specifies information about a stored procedure that is to be replicated. The replication source and destination databases can be primary or replicate databases.

Create a function replication definition in the Replication Server that manages the primary database.

The function replication definition includes:

The function replication definition can optionally include:

Use these commands to work with function replication definitions:

No data is distributed when you create a function replication definition. You must create stored procedures in both the source and destination databases.

If a stored procedure is to be replicated from a primary to a replicate database, you must create a subscription at the replicate Replication Server. You don’t need a subscription for a stored procedure that is to be replicated from a replicate to a primary database.

See “Subscription commands” for commands that you use in subscribing to replication definitions.