Database Edition

By using Microsoft Visual Studio Team System Database Edition, you can take concepts from Microsoft Visual Studio Team System and expand them to include database teams. Database Edition helps you manage database change to extend your team productivity and improve collaboration both within your database teams and between them and the rest of your organization. For the most recent information about Database Edition, see Visual Studio Team Edition for Database Professionals.

In This Section

  • What's New in Database Edition
    Describes features that were added or changed in Team System 2008 Database Edition.

  • Getting Started with Database Edition
    Provides overviews, introductory walkthroughs, glossary definitions, and other basic information to help you start to learn about Database Edition.

  • Creating and Updating Version-Controlled Database Schemas
    Describes how you can use database projects in combination with version control software to manage database change. This section includes overviews of how you can use database projects in a team environment, how database developers can set up isolated development environments in which to work, and how you can define, build, and deploy database objects.

  • Editing Database Scripts and Objects with the Transact-SQL Editor
    Describes how you can use the Transact-SQL (T-SQL) editor to modify database object definitions and to author and execute scripts. This section includes information about how to create an editor session, connect to a database, execute database scripts, and view the results.

  • Generating Data with Data Generators
    Describes how you can use Data Generator to create reproducible test data that does not contain sensitive information. When you use Data Generator in combination with database unit testing and a database project that is under version control, you can verify changes to the database before you share them with the rest of the team, reducing risk.

  • Comparing Databases
    Describes how you can use Data Compare to identify similarities and differences in the data that is contained in two databases. This section also describes how you can use Schema Compare to identify structural differences between databases or between a database and a database project. After you compare either data or schemas, you can then update the target to match the source.

  • Verifying Databases with Unit Tests
    Describes how you can use database unit testing to verify whether database objects, such as stored procedures and triggers, behave as you expect. When you perform unit tests in combination with using Data Generator, you can test for predictable results.

  • Refactoring Databases
    Describes how you can use database refactoring to rename database objects. Other objects that reference the renamed object are automatically updated with the new name.

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

  • Team Foundation
    Provides links to topics about an extensible team collaboration server that all members of the extended information-technology team can use to manage and track the progress and status of projects.

  • Architecture Edition
    Provides links to topics about visual designers, which help architects, operations managers, and developers to design service-oriented solutions that can be validated against their operational environments.

  • Development Edition
    Provides links to topics about advanced development tools, which include code analysis, performance, and testing tools that help teams to build reliable, mission-critical services and applications.

  • Test Edition
    Provides links to topics about a suite of test tools that you can use not only to create, manage, edit, and run tests but also to obtain and store test results. Several test types are integrated into Visual Studio, including unit, Web, load, and manual tests, and you can also perform tests that measure code coverage.