What is the best tool/method of pushing over changes(column additions, procedures, triggers) from developement to production (DDL changes only)
Printable View
What is the best tool/method of pushing over changes(column additions, procedures, triggers) from developement to production (DDL changes only)
There are a few ways to do it. Patrol has a program called change manager that will compare the two environments and create a script to match one with the other. BUT, you need the program and it has to be installed on both boxes.
EXP/IMP will work too, but I am assuming that you do not want to loose data. I'm sure someone in here has a compare SQL script.
MH
thought about a standby database / dataguard?
Maybe a bit overkill for what you need but youdb's should be in sync with each other