verifiying version of database

rbennet8

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?

Eddie D

Hi

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