Creating a Function Replication Definition

Create a function replication definition to indicate a replicated function used in replicated function delivery. The function replication definition, which Replication Server maintains, includes information about the parameters to replicate and the location of the primary version of the affected data.

Prerequisites

Make sure the Replication Server is running. Create and establish a connection to the server.

Expand the tree for the Replication Server connection profile, right-click a primary database for which to create the replication definition, and select New Artifact.
Select Function Replication Definition and click Next.

Specify the primary data location and display options.

Field	Description
Primary Location	Select a Primary Connection Profile Type, Primary Connection Profile Name, Primary Server, and Primary Database. (Optional) Click Create to create a primary connection profile.
Display	Select a display option: Display All Stored Procedures – display all stored procedures in the primary database. Display Marked Stored Procedures Only – display only stored procedures that are marked for replication. Display by Name Pattern – display stored procedures according to the specified name pattern. For example, to display all stored procedures with names that begin with "p", enter `p*` and click Filter.
Function Replication Definition	Select stored procedures in the grid. Use Select All and Deselect All to select or deselect all stored procedures. Use Revert to revert selections.

Click Next, and set the parameter replication settings for each selected stored procedure.

Field	Description
Replicated Stored Procedures	Parameters for the stored procedures highlighted in the Replicated Stored Procedures grid are shown in the Stored Procedures Parameters grid that follows.
Stored Procedure Parameters	Provide information for the applicable parameters and unselect those that do not apply. Parameter Name – displays the parameter names for the specified stored procedure. This field is read-only. Datatype – specify the datatype of the parameter. As a default, this field contains the datatype specified in the DDL defining the stored procedure. To modify this value, enter a new value or select an existing datatype. Searchable – select which parameters you want to be searchable in the replicated stored procedure. Click Invert Selection to invert the status for selected parameters.

Field

Description

Replicated Stored Procedures

Parameters for the stored procedures highlighted in the Replicated Stored Procedures grid are shown in the Stored Procedures Parameters grid that follows.

Stored Procedure Parameters

Provide information for the applicable parameters and unselect those that do not apply.

Parameter Name – displays the parameter names for the specified stored procedure. This field is read-only.
Datatype – specify the datatype of the parameter. As a default, this field contains the datatype specified in the DDL defining the stored procedure. To modify this value, enter a new value or select an existing datatype.
Searchable – select which parameters you want to be searchable in the replicated stored procedure.

Click Invert Selection to invert the status for selected parameters.

Specify save and execution properties.

Field	Description
Generate Script	Generate a SQL file for the replication definition.
Execute Immediately	Execute the SQL code immediately. If you do not select this option, you must complete execution of the SQL file later to create the replication definition.

Click Finish.