Implementing SQL Server Continuous Integration Using Jenkins & Red Gate

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, 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 (, 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 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.

Join or login to comment.

  • A former member
    A former member

    Here's a link to the Prezi deck:

    May 22, 2013

  • Zamir

    Can't wait to meet everyone and pick their brain.

    May 20, 2013

  • Susan K

    Out of town

    May 4, 2013

46 went

Our Sponsors

People in this
Meetup are also in:

Sometimes the best Meetup Group is the one you start

Get started Learn more

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy