Software

Ask something
Discussion Locked

Reverse Engineering

0 helpful
1 reply

by orasu

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Have anyone of you in this forum worked on situations where you had generate DML/DDL for upgrades. I have seen scripts which just lists the differences. I am looking for scripts that might help in comparison and generation of the actual ddl/dml. Anyhelp is appreciated. The DDL/DML that I am looking for is as a result of running a comparison between two databases. One production database and the other with changes that need to make it to the production database.

1 reply

by swstephe

My favorite is, (for Oracle):

set rows 999;
...
spool drop.sql;
/* disable all constraints */
select 'alter table '||table_name
||' disable constraint '||constraint_name||';'
from user_constraints;
/* drop all objects */
select 'drop'||object_name||' '||object_type||';'
from user_objects;
spool off;
@drop

This discussion is closed to new replies.