Creating a Database Replication Definition

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.
You can also start this wizard by right-clicking the Database Replication Definitions folder for a primary database and choosing New Database Replication Definition from the context menu.

Name the database replication definition, and specify primary location details.

Field	Description
Database replication name	Enter a name for the database replication definition.
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.

Field

Description

Database replication name

Enter a name for the database replication definition.

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.

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

Click Next, and specify tables for the database replication definition in the Tables tab.

Field	Description
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.

Specify functions for the database replication definition in the Functions tab.

Field	Description
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.

Specify system procedures and DDL for the database replication definition in the System Procedures & DDL tab.

Field	Description
Replicate selected	Specify whether the selected system procedures are to be replicated or excluded from the database replication definition. To include the selected system procedures, click Replicate selected. To exclude the selected system procedures, click Do not replicate.
Replicate DDL	Check the Replicate DDL check-box to indicate whether or not DDL should be replicated.
Display by name pattern	Enter a text pattern indicating the names of system procedures to be replicated, and click Display. To specify any character, enter "?". To specify any string, enter "*". To show all system 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 system procedure selections.
Specify system procedure filter	Specify system procedure filters, if any.

Specify transactions for the database replication definition in the Transactions tab.

Field	Description
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.

Specify save and execution properties.

Field	Description
Generate script	Select this option to generate the script for the 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 replication definition.

Click Finish to close the wizard.