Create or replace
For procedures/packages etc. it would be great to be able to have a "script as CREATE OR REPLACE" option.
We would use this to generate scripts that could be kept under source control in Mercurial, and applied to the (shared) dev database as needed.
We could also then use the tool to compare whether the database is up to date with the latest changes in source control.
I’ve just put this into our latest code so that we always generate CREATE OR REPLACE where we can. Surprisingly all the integration tests passed so this should make it into the next release.
I don’t think there are any huge issues with always using the CREATE OR REPLACE syntax.
Yes this function would be usefull