Automated deployments, Team City, Octopus Deploy

  • Hello everyone,

    I am currently managing a development teams automated deployment of a .net web application with a sql server backend.

    We are SVN as our source control

    We currently have fully automated for building and deployment of the web portion but are struggling with automating the sql piece.

    Our developers are not comfortable with creating SQL Scripts for all their changes as they are used to using svn to manage the database changes .

    Is there a way to easily do the following.

    1. Have Team City detect changes in the DB project and rebuild the db project.

    2. Have Team City and Octopus deploy then deploy the delta change automatically to environments set up in Octopus Deploy?

    Thanks for

  • This was removed by the editor as SPAM

  • +1 for Redgate.

    I spent a day writing an update script, RGT did a better job in 4 minutes (I had forgotten to refresh a view after the table meta data had changed)

    You can download it and evaluate for 2 weeks. If you are nice to your account manager, they will give you a number of extensions to this if you are struggling to get buy-in from management. (but don't thell them I said that).

    Redgate are also the guys who support Steve Jones and the team behind SQL Server Central and provide such a valuable community so I am happy to support them and use their products (the fact that the products themselves are very good is a bonus)

    The RGT also comes with a management studio plugin for SVN so that you can check code in and out directly from MSSM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply