Creating Database Replication Definitions

A database replication definition is a description of the tables, functions, system procedures, and transactions to be replicated from a primary database.

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 Database Replication Definition, and click Next to start the wizard.

Modify the following input fields.

Specify the location of the primary data

Field	Example
Database Replication Name	The primary database from which data is to be replicated.
Primary Data Location	Specify the following values: Primary connection profile type – the type of connection profile appropriate for your primary data server. Primary connection profile name – the name you have assigned to your primary data server connection profile. Primary server – the name of your primary data server . Primary database – the name of your primary database on the specified data server .

Field

Example

Database Replication Name

The primary database from which data is to be replicated.

Primary Data Location

Specify the following values:

Primary connection profile type – the type of connection profile appropriate for your primary data server.
Primary connection profile name – the name you have assigned to your primary data server connection profile.
Primary server – the name of your primary data server .
Primary database – the name of your primary database on the specified data server .

Note

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

Click Next to continue.

To specify tables for the database replication definition, click the Tables tab in the Create a new database replication definition page, and modify the following input fields.

Specify the primary data tables

Field	Example
Replicate Selected	Specify whether the selected tables are to be replicated or excluded from the database replication definition. To include the selected tables, click Replicate selected. To exclude the selected tables, click Do not replicate.
Display by Name Pattern	Enter a text pattern indicating the names of tables to be replicated, and click Display. To specify any character, enter "?". To specify any string, enter "*". To show all tables, leave this field empty.
Table List	Tables are displayed in the Table list grid. Use Select All, Deselect All, and Revert Selection to adjust your table selections.
Specify Table Filter	Specify table filters, if any.

To specify functions for the database replication definition, click the Functions tab in the Create a new database replication definition page, and modify the following input fields.

Specify the primary data functions

Field	Example
Replicate Selected	Specify whether the selected functions are to be replicated or excluded from the database replication definition. To include the selected functions, click Replicate selected. To exclude the selected functions, click Do not replicate.
Display by Name Pattern	Enter a text pattern indicating the names of functions to be replicated, and click Display. To specify any character, enter "?". To specify any string, enter "*". To show all functions, leave this field empty.
Function List	Functions are displayed in the Function list grid. Use Select All, Deselect All, and Revert Selection to adjust your function selections.
Specify Function Filter	Specify function filters, if any.

To specify system procedures for the database replication definition, click the System Procedures & DLL tab in the Create a new database replication definition page, and modify the following input fields.

Specify the primary system procedures

Field	Example
Replicate Selected	Specify whether the selected system procedures are to be replicated or excluded from the database replication definition. To include the selected procedures, click Replicate selected. To exclude the selected procedures, click Do not replicate. To replicate DDL for selected procedures, click Replicate DDL.
Display by Name Pattern	Enter a text pattern indicating system procedures to be replicated, and click Display. To specify any character, enter "?". To specify any string, enter "*". To show all procedures, leave this field empty.
System Procedure List	System procedures are displayed in the System procedure list grid. Use Select All, Deselect All, and Revert Selection to adjust your procedure selections.
Specify System Procedure Filter	Specify system procedure filters, if any.

To specify transactions for the database replication definition, click the Transactions tab in the Create a new database replication definition page, and modify the following input fields.

Specify the primary transactions

Field	Example
Replicate Selected	Specify whether the selected transactions are to be replicated or excluded from the database replication definition. To include the selected transactions, click Replicate selected. To exclude the selected transactions, click Do not replicate.
Enter Transaction Filters	Specify transaction filters, if any.

When you have finished specifying the tables, functions, system procedures, and transactions for the database replication definition, specify how to handle the commands for creating a database replication definition.
- Click Generate script to have the creation script displayed in the RepServer Scrapbook when you are finished with the wizard. This option is selected by default.
- Click Execute immediately to have the script execute once you are finished with the wizard.

Click Finish to close the wizard.

Creating Function Replication Definitions

Creating Table Replication Definitions