Shortcuts to Creating a Replication

The Management Center window usually offers several ways to accomplish the same goal:

• Via the buttons displayed in the toolbars

• Via the menus displayed when clicking the right mouse button over an item in the Management Center window.

• Via the main toolbar

• Via dragging and dropping items in the Metadata Explorer.

Here are some ways to speed up the process of creating a replication.

Starting Wizards Automatically

The first step in setting up a replication in the Management Center is to create connections to your source and target databases.

Each wizard involved in the creation of a replication provides an option to automatically open the next wizard in the process.

In the Summary screen of the Source Connection wizard, check the option to proceed with the definition of a target connection. Then, in the Summary screen of the Target Connection wizard check the option to open the Replication Wizard.

Using Drag and Drop to Create Tables and Replications

Once you have defined source and target connections, you can use the Metadata Explorer to drag a source table to a target connection to open the Create Target Table wizard, and drag a source table to a target table to open the Replication wizard.

Creating a Target Table

1. In the Metadata Explorer, expand the source and target connections to display both the source table and the target connection.

2. Click and hold the mouse button down on the source table and drag it down to the target connection, then release the mouse button.  

The Create Target Table wizard is launched with the source table and target connection information already selected for you.

Creating a Replication

1. In the Metadata Explorer, expand the source and target connections to display both the source table and the target table.

2. Click and hold the mouse button down on the source table and drag it down to the target table, then release the mouse button.  

The Replication wizard is launched with the source table and target table information already selected for you.