Is it possible to use custom validation when deploying code?

We have some custom validation we use with our current deployment process which runs through some of our internal validation.  Currently, a database object needs to pass that validation before it can be compiled.  The validation is in a PL/SQL package.  Is it possible to tie the deployment process in the Schema Compare to our custom validation and prevent code from being migrated if it doesn't pass the internal validation?
Tagged:

Answers

  • RichardLRichardL Posts: 417 Gold 4
    Hi @ahowlett

    Thanks for your post. 

    In order to do this you would need to select the deployment option to create a script and then you could use your own validation process to validate the script generated by Schema Compare for Oracle. 

    I hope this helps. 

    Richard Lynch. 
    Customer Support
    Redgate Software
  • ...or you could fully automate the generation of the script and the validation using the sco.exe command line using /scriptfile:mydeploymentscript.sql
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.