Editing Database Scripts and Objects with the Transact-SQL Editor

You can edit, validate, and execute database queries, scripts and objects by using the Transact-SQL (T-SQL) editor in Visual Studio Team Edition for Database Professionals.

In This Section

  • 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.
  • Working with Database Scripts
    Contains topics that describe how you create and maintain scripts for deploying database schemas and managing databases.
  • Renaming Database Objects
    Contains links to information about how to rename database objects. Contains links to an overview, important considerations, tasks, and troubleshooting information.
  • 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.
  • 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 a target to match a source.