PASS Community Summit 2008: Program Session (Application Development)

Deploying DB Pro to Multiple Environments

Grant Fritchey

Session Details

This session will show attendees a series of TSQL scripts, command line scripts and various Visual Studio settings and configurations that will enable the attendee to use Visual Studio DB Pro to deploy to multiple environments. It's extremely easy to configure DB Pro to deploy to a single environment. However, when multiple developers or DBA's have to deploy the same project to various disparate environments, the tool becomes more difficult to use. This session will introduce concepts to make this task easier. To begin, attendees will be introduced to project properties that need to be configured to allow for multiple environments. This will also introduce the concept of variables within the DB Pro environment. Visual Studio Configuration Manager will be covered as a method for establishing different settings for different environments. The session will move on to show how the Pre and Post deployment scripts can be manipulated to deal with the requirements of different environments with an emphasis on file placement and security. Command line builds using parameters will be shown. These make all of the previous concepts available for automation. Finally, a method for saving all this information and sharing it with multiple users through source code management (TFS or VSS) will be shown. All the methods and approaches demonstrated are currently in use in a live environment. Attendees will learn mechanisms that allow them to create their own build process that will be repeatable and can be automated.

Register Now for PASS Community Summit 2008!