What are the challenges you face when working across database platforms? Take the survey

Generate deployment script against snapshot

njkroesnjkroes Posts: 5
edited December 21, 2015 9:12AM in SQL CI 2
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?


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5

    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.