Creating a Function Replication Definition

A function replication definition is a description of a replicated function used in replicated function delivery. The function replication definition, maintained by Replication Server, includes information about the parameters to be replicated and the location of the primary version of the affected data.

Open Enterprise Explorer, and connect to your Replication Server.
Expand the view for your Replication Server connection profile, right-click a primary database for which to create the replication definition, and choose New Artifact from the context menu.
From the wizard selection screen, select Function Replication Definition creation wizard, and click Next to start the wizard.
You can also start this wizard by right-clicking the Function Replication Definitions folder for a primary database and choosing New Function Replication Definition from the context menu.

Specify the primary data location and display options.

Field	Description
Primary location	Provide values for the following fields: Primary connection profile type: Choose a connection profile type from the drop-down menu. Primary connection profile name: Choose a connection profile name from the drop-down menu. Click Create to create a primary connection profile. Primary server: Select a primary data server from the menu drop-down. Primary database: Select a primary database from the menu drop-down.
Display	Select a display option: Display all stored procedures: Select this option to display all stored procedures in the primary database. Display marked stored procedures only: Select this option to display only stored procedures that are marked for replication. Display by name pattern: Select this option to display stored procedures according to the name pattern specified in the text field. For example, to display all stored procedures with names that begin with "p", enter p* in the text field, 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.

Note: The commands for creating a function replication definition can be viewed in the Preview field in this and subsequent steps.

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

Field	Description
Replicated stored procedures	The stored procedures selected for replication are displayed in the Replicated stored procedures grid. Any 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	Select parameters with the corresponding check boxes, and provide information for the following fields in the Stored procedures parameters grid, if necessary. By default, all parameters are selected. Parameter Name: These are the parameter names for the specified stored procedure. You cannot edit this field. 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, double-click in the field, and select a datatype from the menu drop-down or type in a datatype. Searchable: Select the checkbox for all parameters you want to be searchable in the replicated stored procedure. Click Invert Selection to invert the status for selected parameters. Use Select All or Deselect All for the entire list.

Field

Description

Replicated stored procedures

The stored procedures selected for replication are displayed in the Replicated stored procedures grid. Any 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

Select parameters with the corresponding check boxes, and provide information for the following fields in the Stored procedures parameters grid, if necessary. By default, all parameters are selected.

Parameter Name: These are the parameter names for the specified stored procedure. You cannot edit this field.
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, double-click in the field, and select a datatype from the menu drop-down or type in a datatype.
Searchable: Select the checkbox for all parameters you want to be searchable in the replicated stored procedure.

Click Invert Selection to invert the status for selected parameters. Use Select All or Deselect All for the entire list.

Specify save and execution properties.

Field	Description
Generate script	Select this option to generate the script for the function replication definition.
Execute immediately	Execute the SQL immediately. If you do not select this option, you must complete execution of the SQL later to create the function replication definition.

Click Finish to close the wizard.