Competition: What’s your favorite Redgate tool? Enter now.

verifiying version of database

rbennet8rbennet8 Posts: 74
edited December 21, 2006 2:30PM in SQL Packager Previous Versions
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

  • Eddie DEddie D Posts: 1,688 Rose Gold 5
    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
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.