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
- Overview of Transact-SQL Editor
Provides an overview of how to create, analyze, and execute scripts and queries in the T-SQL editor.
- Transact-SQL Editing Essentials
Contains topics that describe the most important editing tasks that you can perform by using the T-SQL editor.
- Managing Database Connections within the Transact-SQL Editor
Contains topics that help you connect to a database server or specify a particular database in the T-SQL editor.
- Script Analysis and Execution in the Transact-SQL Editor
Contains topics that help you analyze and run your scripts and queries in the T-SQL editor.
- Walkthrough: Create and Execute a Simple Transact-SQL Script
Explains how to create and execute a simple Transact-SQL script. As part of this walkthrough, you connect and disconnect from the server, validate your T-SQL scripts, and examine the results of the query.
- 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 Team Edition for Database Professionals.
- 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.