verifiying version of database
rbennet8
Posts: 74
Is it possible to include SQL statements in a Pre SQL script that will cause the package to abort? I need to verify database version prior to executing the upgrade package. I have a table that contains the version information and a simple SQL statement can verify the version, but I do see a way to stop the package. Is there a return code from the pre SQL script that is set?
Comments
Thank you for your post into the SQL Packager forum.
To my knowledge there is not a return code for the pre SQL Script.
I am sure that the schema script still loads even if the pre script fails.
The only way of stopping the package at this point would be to edit the script and place some error checking into the code.
Unless any of my Red Gate colleagues know of something else or anyone who uses and reads the forum have generated some similar and willing to help.
Best Regards
Eddie
Red Gate Software
Technical Support
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com