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!!

6 comments:

  1. Replies
    1. The effectiveness of IEEE Project Domains depends very much on the situation in which they are applied. In order to further improve IEEE Final Year Project Domains practices we need to explicitly describe and utilise our knowledge about software domains of software engineering Final Year Project Domains for CSE technologies. This paper suggests a modelling formalism for supporting systematic reuse of software engineering technologies during planning of software projects and improvement programmes in Final Year Projects for CSE.

      Software management seeks for decision support to identify technologies like JavaScript that meet best the goals and characteristics of a software project or improvement programme. JavaScript Training in Chennai Accessible experiences and repositories that effectively guide that technology selection are still lacking.

      Aim of technology domain analysis is to describe the class of context situations (e.g., kinds of JavaScript software projects) in which a software engineering technology JavaScript Training in Chennai can be applied successfully

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. Just admiring your work and wondering how you managed this blog so well. It’s so remarkable that I can't afford to not go through this valuable information whenever I surf the internet.
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training

    ReplyDelete

LinkWithin

Related Posts Plugin for WordPress, Blogger...