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