Visual Studio Team System Database Edition can help you manage the development life cycle of your databases as an integral part of your application development. By managing database change, you can provide better communication and closer coordination between software and database developers.
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.
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.
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.
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.
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.