How can we improve our Oracle tools?

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.

39 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Michael ChristofidesAdminMichael Christofides (Product Manager, Red Gate) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Richard MitchellAdminRichard Mitchell (Project Manager, Red Gate) responded  · 

    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.

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base