Add custom code to Deployment scripts

Hi

I would like to add checks to the Deployment scripts created by SQL Compare such as:

1. checking whether a script is being run at the wrong time

2. the script is being run on the wrong server/database

Is there a way of customising the script templates?  Or, Product Enhancement Alert, could these be added in?

The issue we have is with scripts being run at the wrong time or on the wrong server and if the script itself self-polices, this can be avoided.  Although this info can be added to a ticket, DBA's are only human!

Tagged:

Answers

  • Sergio RSergio R Posts: 610 Rose Gold 5
    Hi,

    When deploying with SQL Compare you can generate a deployment script and then edit it.
    There's also an option to add a database USE statement (which scripts a USE DATABASE (target database).
    Please note that you can use the DLM Automation version of SQL Compare with CI and Release servers which would address your concerns.

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.