Sunday, May 11, 2014

Synchronization between data model and data dictionary in Oracle SQL Developer Data Modeler

This post is regarding how to synchronize data model and the connected data dictionary in Oracle SQL Developer Data Modeler.

Besides reverse engineering, Oracle SQL Developer Data Modeler is able to synchronize the existing data model with the connected or defined Data Dictionary.
Meaning it's able to update the data model when there are new updates in the schema or vice versa.

Steps to synchronize new updates from schema to data model.

1. Click on Synchronize Model with Data Dictionary

2. Select the targeted data dictionary  > Click OK

3. Review the changes from Data Dictionary to be merged into Data Model > Click Merge

4. Database Schema changes merged into Data Model.


Steps to synchronize changes from Data Model to Data Dictionary

1. Click on Synchronize Data Dictionary with Model

2. Select the targeted data dictionary  > Click OK


3. Review the changes from Data Model to be synchronized with Data Dictionary


4. Click on DDL Preview to get the update SQL scripts.

5. Execute the SQL scripts to modify Database Schema.


Done!!

LinkWithin

Related Posts Plugin for WordPress, Blogger...