THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

Data Tools Operations Window (10 days of SSDT – Day 7)

SQL Server Data Tools (SSDT) was released in Spring 2012 and I have been using it to build SQL Server databases nearly every day since then. In that time I’ve learnt a lot about how to make best use of the tool and I want to share that experience in a new series of blog posts called “10 days of SSDT”. I shall be publishing a different blog post every day for 10 days, each day revealing something that you may not know about SSDT. I hope you enjoy the series and contribute via the comments!

SSDT provides feedback on the actions that it is undertaking via the Data Tools Operations window. This is a window that sits within SSDT’s Visual Studio shell and looks something like this:

image

Whenever SSDT publishes an SSDT project (in the offline development scenario) or makes changes to an existing database (in the connected development scenario) progress will be reported in the Data Tools Operations window. For each operation reported in the Data Tools Operations window you have the ability to view:

  • Preview - A  description of the changes that SSDT is intending to make to the target database
  • Script – The T-SQL script that SSDT builds
  • Results – Essentially the output from running the aforementioned script

Here is a typical screenshot of the Preview:

image

As you can it provides a readable, pseudo-code description of what actions SSDT is going to take.

The Data Tools Operations window is a very useful addition to SSDT and its worth highlighting it in this dedicated blog post so that people are aware of its capabilities and, importantly, that it even exists.

If you want to learn more about SSDT then come along to my training course Introduction to SQL Server Data Tools in association with Technitrain on 23rd/24th February 2015 in London. There is a discount if you register before the end of 2014.

Earlier posts in this series:

Published Thursday, September 25, 2014 9:36 AM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Jamie Thomson said:

SQL Server Data Tools (SSDT) was released in Spring 2012 and I have been using it to build SQL Server

September 26, 2014 2:40 AM
 

Jamie Thomson said:

SQL Server Data Tools (SSDT) was released in Spring 2012 and I have been using it to build SQL Server

October 1, 2014 2:37 AM
 

Jamie Thomson said:

SQL Server Data Tools (SSDT) was released in Spring 2012 and I have been using it to build SQL Server

October 13, 2014 2:57 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Privacy Statement