Export (0) Print
Expand All

How do I Team Edition for Database Professionals

Visual Studio 2005

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

Show:
© 2014 Microsoft