How To Handle Deployment to Production The First Time

sheldonhullsheldonhull Posts: 33 Silver 1
Working on implementing ReadyRoll. Have been importing any changes being made in the production/dev enviroments. We'll be testing the UAT/DEV versions, and then finally releasing to production. 

Changes made that aren't yet in production are in following migration scripts, but the baseline itself is what "production looks like". I need to ensure that the baseline itself is bypassed on the run of the sqlpackage. 

I couldn't find clarity on how to do this, though some articles did provide general help when you were connecting directly in visual studio to setup deployment target. 

Answers

  • dnlnlndnlnln Posts: 234 Gold 2
    edited May 2, 2018 6:56AM
    Hi Sheldon,

    You can get a preview of the baseline+migrations to be executed by generating a patch deployment script for a given SQL Server environment. This can be done within your build server or via the command prompt as described in this article.

    When it comes to applying the baseline, if you don't want to deploy it in the usual way (i.e. by deploying a package), the generated script can then be executed in SSMS directly or by invoking the Deploy target in MSBuild.

    Any questions or issues please let me know.
    Daniel Nolan
    Product Manager
    Redgate Software
Sign In or Register to comment.