23.2. Schedule Snapshot

There are two ways to migrate tables from Oracle database to EnterpriseDB. Along with the plain Online Migration of tables from Oracle to EnterpriseDB database, Developer Studio can also be used to take a snapshot of the tables after a regular interval. The Schedule Snapshot functionality helps us in keeping same tables present in different databases in synchronization. In this example, Developer Studio will take a snapshot of the tables from the Oracle database and will update the tables present in EnterpriseDB database.

Here we will take Schedule Snapshot of a tables present in Oracle database under HR schema. Right click on the table and select the Schedule Snapshot option as shown below:

As you select the Schedule Snapshot option, the following Schedule Snapshot window will appear.

We can take a snapshot of the table(s) after a fixed interval, or at a particular time of the day as shown above.

The Server and Database fields indicate the server and the database name where the target tables exist. Schema indicates the target schema name. Selecting the Export Constraints and Export Indexes check boxes will export data with key and index constraints. Here we will be taking a snapshot after every 12 hours hence we have selected the Repeat Interval option.

Once all the target information is filled, click on the Run button to execute.

If migration aborts on a particular item, then it does not roll back. All items before that item will now be present in your target database. Similarly if abort occurs while a table is being loaded then all transactions that have been executed before abort will be present in the target database.