Platinum Sponsor

Automated Database deployment with SSDT

Deploying schema changes and database code to a live server can be a nerve-wracking experience fraught with danger with every script. The smallest error can cause untold amounts of downtime, this is bad for in-house systems but for ecommerce systems its catastrophic. Database changes are permanent, there is no ‘undo’ , there is no rollback. There is no safety net. If something goes wrong we have to fix forward, let us hope that we get that right and not compound the error. We cant just put back the old code and revert to a previous version. In this session we shall look at the options of deploying database changes, and how we can automate many of the manual steps involved. 
Presented by Dave Ballantyne at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    dave_ballantyne.jpg
    Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years,  the past 15 of which has been specialising within SQLServer environment. 
    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.