Toad World® Forums

Concept of an Execution Dry Run


Was speaking with a customer today... adding this idea on her behalf. 

Would be valuable for both Toad for Oracle and the Toad DevOps Toolkit to have a utility/capability that allows for the concept of a "dry run".  The idea is that before a database change script gets executed on the target database, have Toad check the impact of the proposed changes, but WITHOUT actually executing the script: 

  • Would there be any syntax errors? (Toad can do this already, but in addition...)
  • Would there be any logical errors?
  • Are changes lined up in correct dependency order?
  • Do targeted objects exist, or exist in the correct definitional state?
  • Would applying the change result in an error condition?
  • While the change may be ok for the intended object, what about dependent objects?
  • Would any data be lost?
  • ETC.  (think of more here)

Customer indicated that such a capability does exist, but is part of Oracle's set of internal utilities and not exposed to the public for general consumption?

Use case is pretty clear here... this capability would stop a DevOps change process cold if there's a hint that the database change script won't produce a successful push.