Is it possible to use custom validation when deploying code?

ahowlett

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?

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. 

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