Starting Team Database Development

Before you can manage changes to database objects and settings or to server objects and settings, you must first create a database project or a server project. The project is the offline representation of the objects and settings for the database or server. For more information, see An Overview of Database and Server Projects.

You can import objects and settings from an existing database or server, or you can define objects and configure settings within the project that you just created. You then check in the project to version control, from which the team can build and deploy changes to isolated development environments. For an overview of how Visual Studio Team System Database Edition helps you manage changes to your database, see Managing Database Change.

Common Scenarios

The following table contains common scenarios that you might encounter when you start to develop databases in a team environment.


Supporting Content

Your database does not refer to other databases, shared server objects, or SQLCLR objects.

Starting Team Development of Databases

Your database refers to at least one other database.

Starting Team Development of Databases That Reference Other Databases

Your database refers to at least one SQL common language runtime (CLR) object.

Starting Team Development of Databases That Reference SQLCLR Objects

Your database refers to shared server objects, such as logins or keys.

Starting Team Development of Databases that Reference Shared Server Objects

You want to manage changes to large databases.

Starting Team Development of Large Databases

Your database uses one or more XML Schema Collections.

Starting Team Development of Databases that Use XML Schema Collections

Supporting Content

The following table contains additional content that supports the previous scenarios.


Supporting Content

Migrate existing database scripts: You can use your existing database scripts in another version control system to begin team development in Database Edition.

Migrating from Another Version Control System to Team Foundation Server and Database Edition

See Also


Terminology Overview of Database Edition