How do I in Database Edition
This page contains links to topics about common tasks that you perform with Visual Studio Team System Database Edition.
Overviews
Managing Database Change
Describes how you can use Database Edition to manage your database as part of your overall application development.Architectural Overview of Database Edition
Provides an overview of the architecture of Database Edition 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 Database Edition, including safety considerations.Overview of Comparing Database Data
Describes aspects of the data-comparison functionality in Database Edition.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 Visual Studio Team System Team Foundation Server.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 Database Edition displays after it compares two schemas.
See Also
Concepts
Terminology Overview of Database Edition