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 System Database Edition.

In This Section

  • Getting Started with Visual Studio Team Edition for Database Professionals
    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.

  • 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.

  • Database Unit Testing
    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.