Generate deployment script against snapshot

njkroes

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?

Eddie D

Hi

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