How can we help you today? How can we help you today?

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?
ahowlett
0

Comments

2 comments

Sort by
  • RichardL
    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.
    RichardL
    0
  • David Atkinson
    ...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
    0

Add comment

Please sign in to leave a comment.