How should I migrate DDL changes from one environment to the next?
Posted
by Rl
on Stack Overflow
See other posts from Stack Overflow
or by Rl
Published on 2010-03-08T20:35:07Z
Indexed on
2010/03/08
22:51 UTC
Read the original article
Hit count: 191
I make DDL changes using SQL Developer's GUI. Problem is, I need to apply those same changes to the test environment. I'm wondering how others handle this issue. Currently I'm having to manually write ALTER statements to bring the test environment into alignment with the development environment, but this is prone to error (doing the same thing twice). In cases where there's no important data in the test environment I usually just blow everything away, export the DDL scripts from dev and run them from scratch in test.
I know there are triggers that can store each DDL change, but this is a heavily shared environment and I would like to avoid that if possible.
Maybe I should just write the DDL stuff manually rather than using the GUI?
© Stack Overflow or respective owner
