How do I Team Edition for Database Professionals

This page contains links to topics about common tasks that you perform with Microsoft Visual Studio Team Edition for Database Professionals.

Overviews

• Managing Database Change
  Describes how you can use Visual Studio Team Edition for Database Professionals to manage your database as part of your overall application development.

• Architectural Overview of Team Edition for Database Professionals
  Provides an overview of the architecture of Team Edition for Database Professionals and how it relates to other parts of Visual Studio Team System.

• 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.

• Overview of Generating Data
  Describes the uses and capabilities of the data generation functionality.

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

• Overview of Comparing Database Schemas
  Describes aspects of the schema-comparison functionality in Team Edition for Database Professionals, including safety considerations.

• Overview of Comparing Database Data
  Describes aspects of the data-comparison functionality in Team Edition for Database Professionals.

• Overview of Transact-SQL Editor
  Provides an overview of how you can create, analyze, and execute scripts and queries in the Transact-SQL (T-SQL) editor.

Walkthroughs

• Walkthrough: Creating an Isolated Database Development Environment
  Describes how you can 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. This step is typically performed by someone in an administrative role.

• Walkthrough: Establishing a Baseline for the Isolated Development Environment
  Describes how 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
  Describes how you can refactor the database project to change a column name and then test your changes in an isolated development environment.

• Walkthrough: Creating and Running a Data Generation Plan
  Describes how you can create and run a data generation plan to fill tables with random data.

• Walkthrough: Comparing the Schemas of a Database and Database Project
  Describes how you can compare the schema of a database project (the source database) with the schema of a deployed database (the target database).

• Walkthrough: Comparing the Data of Two Databases
  Describes how you can compare data in two databases.

• Walkthrough: Creating and Running a Database Unit Test
  Describes how you can generate a unit test and add T-SQL code and C# test conditions to that test.

• Walkthrough: Renaming a Database Column
  Describes how you can create a database project, import a database schema, and rename a database object.

• Walkthrough: Deploying Database Refactoring Changes
  Describes how you can set deployment properties for a refactored database project, build the project, and then deploy the project. You also compare the live database before and after deployment by using Server Explorer.

• Walkthrough: Create and Execute a Simple Transact-SQL Script
  Describes how you can create and execute a simple Transact-SQL script. As part of this walkthrough, you connect and disconnect from the server, validate your T-SQL scripts, and examine the results of the query.

Preparing an Isolated Development Environment

• How to: Create Database Projects
  Describes how you can use the New Database Project Wizard to create a database project for an existing database and import the schema for that database into the database project.

• How to: Configure Database Projects for Build and Deployment
  Describes how you can configure build and deployment options for your database project by using the Database Project properties.

• How to: Put Database Projects Under Version Control
  Describes how you can put your database project under version control such as Microsoft Visual Studio 2005 Team Foundation Server or Microsoft Visual SourceSafe.

• How to: Create Data Generation Plans
  Describes how you can create a data generation plan.

• How to: Specify Tables for Data Generation
  Discusses the restrictions and requirements for what tables you can and cannot include in a data generation plan. Describes how you can specify tables in a data generation plan.

• How to: Specify Columns for Data Generation
  Lists the steps to specify columns in a data generation plan.

• Specifying Details of Data Generation for a Column
  Lists the steps to specify what kind of data will be generated for each column.

• How to: Deploy Changes to New or Existing Databases
  Describes how you deploy the build script for a new or existing database.

• How to: Specify the Local Instance of SQL Server to use for Design-time Validation
  Describes how you specify the instance of Microsoft SQL Server 2005 that you want to use for design-time validation.

Performing Iterative Development Tasks

• How to: Create a Database Object
  Describes how you can create database objects, such as tables, views, and stored procedures.

• How to: Modify Database Objects
  Describes how you can modify the definitions of database objects, such as tables, views, and stored procedures.

• How to: Rename Database Objects
  Lists the steps to rename a database schema object and describes the effect on other objects in the database project.

• How to: Run a Data Generation Plan to Generate Data
  Lists the steps to run a data generation plan and generate data.

• How to: Create Database Unit Tests for Functions, Triggers, and Stored Procedures
  Explains how to create a database unit test with T-SQL code stubs from these database objects.

• How to: Add Test Conditions to Database Unit Tests
  Describes how you can add test conditions by using the Database Unit Test Designer.

• How to: Configure Database Unit Test Execution
  Describes how you can specify settings that control how your test connects to the database that you will test, how you deploy a schema from a database project to that database, and whether you populate the database with data.

• How to: Run Database Unit Tests
  Describes how you can run database unit tests by using the Test View window.

Getting Ready for Deployment to Production

• How to: Specify Pre-Deployment or Post-Deployment Scripts
  Describes how to specify scripts to be run before or after the deployment of your database.

• How to: Prepare Database Build Scripts
  Describes how you generate a build script to create a database whose schema matches the database project.

• How to: Start the Transact-SQL Editor
  Describes several methods by which you can start the T-SQL editor to create, modify, or execute scripts.

• How to: Set Options for Comparing Database Schemas
  Describes how to configure what is considered a difference when you compare schemas.

• How to: Compare the Schemas of Two Databases
  Describes how to compare the schemas of two databases.

• How to: View Schema Differences
  Describes how to interpret the data that Team Edition for Database Professionals displays after it compares two schemas.

See Also

Concepts

Terminology Overview of Team Edition for Database Professionals

Other Resources

Troubleshooting (in Team Edition for Database Professionals)