Deployment Model

  • Francis Rodrigues
  • Michael Coles
  • David Dye

Abstract

Version 2012 of SQL Server Integration Services introduces an entirely new way to deploy ETL processes. In prior versions, the individual package was the deployed object. With the new deployment model, the entire project becomes the deployed object. As noted in previous chapters, the inclusion of parameters and project-level connection managers facilitate this new deployment model. One of the advantages of this new model is that it enables you to create environments within SQL Server with specific values to be used for parameters. Just as Edsger Dikstra suggests that program testing is not meant to show the absence of bugs, the ability to emulate environments with this new deployment model should greatly expedite detecting potential bugs.

Keywords

Migration 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Francis Rodrigues, Michael Coles, and David Dye 2012

Authors and Affiliations

  • Francis Rodrigues
  • Michael Coles
  • David Dye

There are no affiliations available

Personalised recommendations