Generate deployment script against snapshot
Our production environment is in secure, separate location. For deployments, we have to generate a SQL script to be run in production manually. Our build server does not have contact with our production database.
For deployments, we generate a snapshot using SQL Snapper against our production database. Then we copy that down and compare it against source control to generate a change script using SQL Compare.
I am now attempting to automate this process using Team City and having a job that generates the deployment script.
Is there a way using SQLCI in the command line to compare a package from the build step against a database snapshot and output a deployment script?
For deployments, we generate a snapshot using SQL Snapper against our production database. Then we copy that down and compare it against source control to generate a change script using SQL Compare.
I am now attempting to automate this process using Team City and having a job that generates the deployment script.
Is there a way using SQLCI in the command line to compare a package from the build step against a database snapshot and output a deployment script?
Comments
Thank you for your forum post.
Sadly within SQL CI, you cannot automate in the manner that you seeking, using a SQL Compare snapshot file.
However as you are using Team City, you can configure Team City to call the SQL Compare command line where you will be able to compare a snapshot file with a live database. This action will require DLM Automation Suite license.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com