Add custom code to Deployment scripts

RedFive

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!

Sergio R

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,