To
create a Replication Schedule:
Select the object Replication Schedule from the tree. The following window is displayed.

Click Create. The Create Schedule Wizard Introduction window is opened.

Click Next. The Select the Remote Database Name window is opened.

If you choose to enter the remote database name manually, click the Enter Data Manually check box and enter the Remote Database Name.
Select the Remote Database Type from the menu.
If you do not choose to enter data manually, you can select the Remote Database Name and the Remote Database Type from the respective menus.
Enter the User ID for the remote database
Enter the password
Click the Express check box if you want to enable express asynchronous table replication
Click Next. The Start Time of Replication and Replication Period window will open.

Enter the date on which the Asynchronous Table Replication is to be started in the Start Date box.
Enter the starting time of Asynchronous Table Replication in the Start Time box.
In the Time interval between subsequent replications field:
Enter the number of days between which the Asynchronous Table Replication will be done in the Days combo box.
Enter the interval of time in which the Asynchronous Table Replication will be done by entering the time interval in hours, minutes and seconds in the Hours:Min:Sec combo box. The total time between replications is equal to the sum of the Days and Hours:Min:Sec fields.
Click Next. The Reconnection Options window is displayed.

Enter the number of times the replication process has to be retried if any failure occurs and replication has not been completed in the Times to Retry combo box. Using the upward and downward arrows, you can increase or decrease the number.
Enter the time duration the replication process has to wait before trying again in the Interval box. Using the upward and downward arrows, you can increase or decrease the number.
Click the Do not check schema check box if you do not want the Replication process to check the table schema before replicating.
Click the Stop on error check box if you want the Replication process to stop if any error is encountered.
Note: The Stop on error check box will be disabled if you want an Express Asynchronous Table Replication.
Click Next. The following window is displayed.

The SQL script for replication schedule creation is displayed. You can modify it if required.
Click Finish. The Information dialog box is displayed as follows.

Click OK and the message will disappear.
Related topic: