Introducing Team Database Professional
• Team DB Pro was designed with the database developer in mind. So what can Team DB Pro do exactly?
- In a nutshell, Team DB Pro was created to help SQL Server 2000/2005 database developers.
- Allowing them to create solutions using the same development practices used by software developers.
- Providing full support for Agile (iterative) methods and version control.
• With Team DB Pro, you create a database project that represents a database’s schema with all its
database objects.
- However, it does not contain the actual data itself.
- This project contains the scripts needed to create or update a database based on the schema and objects.
- A testing database (called an isolated development environment) can be created from these scripts.
• Database designers can create, compare and store database designs (called database schemas) in an SCM
(Software Configuration Manager).
- Team Foundation Source Control or Visual SourceSafe are SCMs.
- You can create a database schema from an existing database.
- You can also create a database schema from a SQL script.
- Once created, this schema can be entered and versioned in source control, offering you the capability of
rolling back a database to a previous version.
• By default, Team DB Pro is not included with the installation of Visual Studio Team Suite.
- However, when you buy Visual Studio Team Suite, you are automatically licensed for Team DB Pro.
- It is installed separately after you install Team Suite. Mind you, it can also be installed as the only
Team edition of Visual Studio.
• Team DB Pro works with Microsoft SQL Server 2000 and SQL Server 2005.
- Please note that it requires at least one installation SQL 2005 (local or remote) in order for it to run.
- Thankfully, SQL Express 2005 (free!) suffices. You may have installed SQL Express 2005 when you
installed Visual Studio.
• You can compare data or database schemas between two existing databases.
- This is helpful in determining what changes occurred to the original database design or to the data it
holds.
- You also have the ability to work with database schemas “off line” using database projects, without
interacting with real databases.
• Team DB Pro eases your pain while performing database design modifications that force changes to
several database objects.
- For example, if you change a column name in a database table, it can automatically replicate that change
to all the database tables, stored procedures, triggers and functions that reference it.
- Before you commit to the changes, Team DB Pro gives you a preview of everything as it will appear
afterwards - awaiting your approval!
• Unit testing can be performed on database objects to ensure quality data processing.
- A new test type is added if you have Team Tester installed called a “Database Unit” test.
- This allows you to test database objects, such as stored procedures, triggers and UDFs (User Defined
Functions).
• Team DB Pro can be used to refactor a database.
- Specifically, Team DB Pro supports rename refactoring.
- Rename refactoring allows you to change a schema object’s name and have that change replicate
throughout the entire database project.
- For example, if you rename a column in a database table, the change is automatically replicated through
the database schema’s stored procedures, triggers, functions, views, and everything else referencing that
particular column.
• Once you are satisfied with the changes performed to a database schema, you can deploy the changes to
a real database.
- Team DB Pro can be used to either fully deploy or an incrementally update a database.
- Team DB Pro uses MSBuild to create the installations.
• In order to interact with an existing database or its schema in Team DB Pro, you need certain SQL
Server permissions.
- These permissions are based on the actions you want to perform, such as comparing database schemas,
generating test data or deploying a database.
• Team DB Pro was designed with the database developer in mind. So what can Team DB Pro do exactly?
- In a nutshell, Team DB Pro was created to help SQL Server 2000/2005 database developers.
- Allowing them to create solutions using the same development practices used by software developers.
- Providing full support for Agile (iterative) methods and version control.
• With Team DB Pro, you create a database project that represents a database’s schema with all its
database objects.
- However, it does not contain the actual data itself.
- This project contains the scripts needed to create or update a database based on the schema and objects.
- A testing database (called an isolated development environment) can be created from these scripts.
• Database designers can create, compare and store database designs (called database schemas) in an SCM
(Software Configuration Manager).
- Team Foundation Source Control or Visual SourceSafe are SCMs.
- You can create a database schema from an existing database.
- You can also create a database schema from a SQL script.
- Once created, this schema can be entered and versioned in source control, offering you the capability of
rolling back a database to a previous version.
• By default, Team DB Pro is not included with the installation of Visual Studio Team Suite.
- However, when you buy Visual Studio Team Suite, you are automatically licensed for Team DB Pro.
- It is installed separately after you install Team Suite. Mind you, it can also be installed as the only
Team edition of Visual Studio.
• Team DB Pro works with Microsoft SQL Server 2000 and SQL Server 2005.
- Please note that it requires at least one installation SQL 2005 (local or remote) in order for it to run.
- Thankfully, SQL Express 2005 (free!) suffices. You may have installed SQL Express 2005 when you
installed Visual Studio.
• You can compare data or database schemas between two existing databases.
- This is helpful in determining what changes occurred to the original database design or to the data it
holds.
- You also have the ability to work with database schemas “off line” using database projects, without
interacting with real databases.
• Team DB Pro eases your pain while performing database design modifications that force changes to
several database objects.
- For example, if you change a column name in a database table, it can automatically replicate that change
to all the database tables, stored procedures, triggers and functions that reference it.
- Before you commit to the changes, Team DB Pro gives you a preview of everything as it will appear
afterwards - awaiting your approval!
• Unit testing can be performed on database objects to ensure quality data processing.
- A new test type is added if you have Team Tester installed called a “Database Unit” test.
- This allows you to test database objects, such as stored procedures, triggers and UDFs (User Defined
Functions).
• Team DB Pro can be used to refactor a database.
- Specifically, Team DB Pro supports rename refactoring.
- Rename refactoring allows you to change a schema object’s name and have that change replicate
throughout the entire database project.
- For example, if you rename a column in a database table, the change is automatically replicated through
the database schema’s stored procedures, triggers, functions, views, and everything else referencing that
particular column.
• Once you are satisfied with the changes performed to a database schema, you can deploy the changes to
a real database.
- Team DB Pro can be used to either fully deploy or an incrementally update a database.
- Team DB Pro uses MSBuild to create the installations.
• In order to interact with an existing database or its schema in Team DB Pro, you need certain SQL
Server permissions.
- These permissions are based on the actions you want to perform, such as comparing database schemas,
generating test data or deploying a database.
VSTS for Database Professionals
Table of Contents
Copyright (c) 2008. Intertech, Inc. All Rights Reserved. This information is to be used exclusively as an
online learning aid. Any attempts to copy, reproduce, or use for training is strictly prohibited.
online learning aid. Any attempts to copy, reproduce, or use for training is strictly prohibited.
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Courseware
Training Resources
Tutorials