Synchroning ORACLE schema

[Pavel Jurzykowski]

Hello,
it seems that EA has no ability to synchronize modified database model into real database schema (using ALTER TABLE).

Example: I create a schema in EA in database modeling. Then I generate scripts and put everything into real database (schema in ORACLE). Then I continue with analyzing/developing and we have found that another modification must be done (for example a new column). I made a modifications into EA in database modeling, but there is no way how to synchronize this modifications into existing schema.

It's very unhandy/ugly, because I have to make a modification into EA (to keep a documentation for developers) and then manually make modifications into database schema to have model and schema synchronized.

Is there any work-around for this? Do you have some recommented workflow for this?

[Geert Bellekens]

Pavel,

I think that is indeed the case. AFAIK there's no ALTER functionality in EA.
I don't know of any work-around, but we don't use the "generate ddl" functionality.

Geert

[Pavel Jurzykowski]

Hello,
i think I have found some solution. The issue can be solved by Oracle procedure, which would make a synchronization between selected EA diagram (parameter1) and destionation schema (parameter2).

Prerequisites will be:
- EA repository must be stored in ORACLE schema
- EA repository must be in the same ORACLE database like destination schema
- sync procedure which will be in dest schema must have access to real EA repository tables
- syncing must be done with calling procedure manually (not from GUI)

The only question is, when I will have a time for implementing this