Chapter 18: SSIS Software Development Life Cycle


Overview

Software Development Life Cycles play an important role in any type of application development. Many SQL Server database administrators and DTS developers have little experience with Microsoft Source Control tools because the tools themselves have been less than "database project-friendly." Microsoft has responded with a more reliable version of Visual SourceSafe and a new source control architecture called Team System.

In addition, many SQL Server DBAs have not been involved with Software Development Life Cycles beyond executing scripts attached to change control documentation. Recent legislation in the United States has changed the role of the SQL Server DBA in the enterprise. Regarding Software Development Life Cycles, DBAs now must participate in ever-earlier phases of the project development.

In addition, SQL Server DBAs — especially SSIS developers — will realize greater productivity and development cycle fault tolerance as they employ source-controlled development practices. These practices produce code that is auditable, an added benefit in the current corporate climate.

This chapter provides an overview of some of the available features in Microsoft's new offerings. It includes a brief description of how to store a project in Visual SourceSafe and a detailed walk-through that describes creating a Team Project — using Visual Studio Team System — for SSIS. In practice, Team Projects will most likely be created by someone else in the software development enterprise.

Note

A more detailed examination of Team System is beyond the scope of this book but may be found in Professional Visual Studio 2005 Team System by Jean-Luc David et al. (Wrox, 2006).

Because the line between database administrator and software developer has blurred and blended over the years, the Team Project walk-through is built in Visual Studio 2005. In the Team Project walkthrough, you are going to put together a project that uses the source control and collaboration functionality provided by Visual Studio Team System to demonstrate working with the tool and complying with your SDLC process.

This chapter also contains information about debugging and breakpoints — highlighting features new to database administrators and DTS developers in SSIS.

Included is a discussion regarding development and testing with an admitted bias toward the agile development methodology. In the author's humble opinion, there are two types of developers: those who use agile methodologies and those who will.

The chapter concludes with a discussion about managing package deployment.



Professional SQL Server 2005 Integration Services
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net