How do I generate DDL for changes in model

user594312 Dec 9, 2013 2:14 PM

I'm using SQL Developer 4 to mantain my logical and physical diagramas. I know how to generate the diagram and generate DDL. But how do I only generate the DDL changes?

Regards,

Néstor Boscán

1. Re: How do I generate DDL for changes in model

thatJeffSmith-Oracle Dec 9, 2013 3:18 PM (in response to user594312)

Basically you want to compare the model with the data dictionary, see the big arrow buttons up on the main toolbar.

In depth answer here:
http://www.thatjeffsmith.com/archive/2012/03/diffs-and-alter-scripts-via-oracle-sql-developer-data-modeler/
Like Show 0 Likes(0)

Actions
2. Re: How do I generate DDL for changes in model

user594312 Dec 9, 2013 3:36 PM (in response to thatJeffSmith-Oracle)

Will this work with different database like SQL Server and DB2?
Like Show 0 Likes(0)

Actions
3. Re: How do I generate DDL for changes in model

thatJeffSmith-Oracle Dec 9, 2013 3:38 PM (in response to user594312)

I believe so.
Like Show 0 Likes(0)

Actions

Go to original post