Create a database replication definition to indicate the tables, functions, system procedures, and transactions to replicate for a primary database.
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
Database Replication Definition and click
Next.
-
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
|
Select a Primary Connection Profile Type, Primary Connection Profile Name, Primary Server, and Primary Database. (Optional) Click Create to create a primary connection profile.
|
- Click Next to specify tables for the database replication definition in the Tables
tab.
| Field |
Description |
|---|
| Replicate Selected
|
Specify whether to include (Replicate Selected)
or exclude (Do Not Replicate)
the selected tables in the database replication definition. |
| 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 |
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 to include (Replicate Selected)
or exclude (Do Not Replicate)
the selected functions in the database replication definition.
|
| 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 |
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 to include (Replicate Selected)
or exclude (Do Not Replicate)
the selected system procedures in the database replication definition.
|
| Replicate DDL
|
Select Replicate DDL to replicate the DDL.
|
| 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 |
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 to include (Replicate Selected)
or exclude (Do Not Replicate)
the selected transactions in the database replication definition.
|
| Enter Transaction Filters |
Specify transaction
filters, if any.
|
- 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.