This page contains links to topics about common tasks that you perform with Microsoft Visual Studio Team Edition for Database Professionals.
Overviews
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
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
See Also