Introductory Walkthroughs

This section contains walkthroughs that introduce you to the key themes and features of Visual Studio Team System Database Edition. These walkthroughs focus on a primary scenario for the product, in which each database developer performs iterative development in an isolated development environment. This type of environment represents a private work space and is sometimes referred to as a sandbox. By following these walkthroughs, you can learn how to set up this type of environment and how team members can work within it to maximize both productivity and quality.

In This Section

• Walkthrough: Creating an Isolated Database Development Environment
  In this walkthrough, you create a database project, import the schema from an existing database, and then add the resulting database project to version control. You also set up the database project properties for build and deployment. These tasks are typically performed by a team member in a more administrative role.

• Walkthrough: Establishing a Baseline for the Isolated Development Environment
  In this walkthrough, you can create unit tests for the existing database and set up a test data generation plan. If you have existing test assets for the database, you can incorporate them also.

• Walkthrough: Performing Iterative Database Development in an Isolated Environment
  In this walkthrough, you refactor the database project to change a column name, and then you test your changes in the isolated development environment.

Related Sections

• Managing Database Change
  Provides an overview of the goals and themes of Visual Studio Team Edition for Database Professionals.

• An Overview of Database Creation and Deployment in a Team Environment
  Provides background information about how you create, update, and deploy a version-controlled database schema.

• An Overview of Database Build and Deployment
  Provides an overview of the steps for building and deploying a new or existing database.

• Overview of Generating Data
  Describes the uses and capabilities of Data Generator.

• Overview of Database Unit Testing
  Introduces database unit testing and describes the structure and contents of a database unit test.

• Overview of Rename Refactoring
  Provides an overview of how you can rename a database object and describes the effect on other objects in the database project.

• Terminology Overview of Database Edition
  Describes terminology associated with the features of Database Edition.