Implementing SQL Server Continuous Integration Using Jenkins & Red Gate
Details
Speaker: Ernest Hwang of Practice Fusion
At this meeting, you'll learn how to simplify your database deployments, ensure that no database changes are overlooked, and implement unit tests using the suite of Red Gate developer tools.
You'll see how Practice Fusion streamlines database deployments in their Integration, http://photos1.meetupstatic.com/photos/event/a/2/8/2/event_211301602.jpeg (http://www.practicefusion.com/)Testing, Staging, and Production environments. This frees developers from the burden of maintaining deployment scripts, while reducing the number of overlooked breaking changes to zero.
The demo will use a Windows Azure box as the Jenkins (Continuous Integration) server and several SQL Azure databases (representing Integration and QA environments). The entire repository will be hosted on GitHub (https://github.com/CF9/Databases.RGDemo), for anyone to download.
You'll learn how to:
Add your database to source control in under five minutes Create a CI Job to validate your database “build” Deploy database changes to your environments with a mouse click Set up database unit testing using tSQLt Avoid problems when implementing Database CI in the “real-world” Ernest Hwang is a Principal Software Engineer at Practice Fusion in San Francisco and has been working with SQL Server since 1999 and .NET since 2001. For the past two years, Ernest has been using Red Gate SQL Source Control, SQL Compare, SQL Data Compare, and SQL Test to automate Practice Fusion's Continuous Integration efforts and instrument database deployments.
Practice Fusion (http://www.practicefusion.com/) is the fastest growing Electronic Health Record community. Over 150,000 physicians and practice managers in 50 states currently use Practice Fusion’s Electronic Health Record.