addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Implementing SQL Server Continuous Integration using Jenkins & Red Gate

  • Apr 10, 2013 · 6:30 PM
  • This location is shown only to members

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. 

During the raffle, you might win a free license of Red Gate's SQL Source Control (valued at $395).

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

    For those of you who attended, everything (including the PowerPoint presentation and a backup of the database) can be downloaded from GitHub at

    April 11, 2013

No one went

Our Sponsors

People in this
Meetup are also in:

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