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 freelance data mangler in London

Which version of SSDT Database Projects do I have installed?

SQL Server Data Tools (SSDT) is released on a very regular cadence (note that I’m talking about the database projects part of SSDT, this is nothing to do with SSIS/SSAS/SSRS). Since the first release in March 2012 there have been releases in September 2012, November 2012, & December 2012. I personally have found it difficult to keep track of not only which particular version I am using but also that which are my colleagues are using – quite simply I didn’t know how to discover the current version number. I assumed that the answer would lie within Visual Studio 2012 in the Help->About Microsoft Visual Studio menu option, when I checked there I saw this:

SNAGHTML339e96a2

A version number – 11.1.21208.0. What does that mean though? To understand more we have to go to Add/Remove programs:

SNAGHTML42d8efe8

There are many different items listed there, let’s look at them in turn:

  • Microsoft SQL Server 2012 Data-Tier App Framework. This is fairly self-explanatory if you know what the Data-Tier App Framework (aka DACFx) is. If you don’t, see the notes at the end of this blog post*. The reason that you see two entries in the list above is due to my having the 32bit & 64bit versions installed – the fact that there is no differentiation between the two in the title is a bug.
  • Microsoft SQL Server 2012 Express LocalDB. LocalDB is the small server-less version of SQL Server that now gets deployed with SQL Server proper. LocalDB also gets installed with SSDT if you do not already have it, but you should consider it part of SQL Server itself.
  • Microsoft SQL Server Data Tools 2010. This was described to me as the “installation chainer” – it is the installation component that manages SSDT and its dependencies. I think of it as the SSDT shell within Visual Studio 2010.
  • Microsoft SQL Server Data Tools 2012. This was described to me as the “installation chainer” – it is the installation component that manages SSDT and its dependencies. I think of it as the SSDT shell within Visual Studio 2012. Note that the version number is the same as in the Help->About screenshot at the top of this article – that is because they are one and the same.
  • Microsoft SQL Server Data Tools – Database Projects – Web installer entry point. A stub project that gets installed when you install SQL Server. Its the SSDT database project entry point.
  • Microsoft SQL Server Data Tools – enu (10.3.21208.0) & Microsoft SQL Server Data Tools – enu (11.1.21208.0). These are the things we’re interested in. These *are* SSDT database projects, for Visual Studio 2010 & Visual Studio 2012 respectively. The version numbers are those for the December 2012 release; note that the build numbers are the same (X.X.21208.X), only the major and minor numbers are different.
  • Microsoft SQL Server Data Tools Build Utilities – enu (10.3.21208.0) & Microsoft SQL Server Data Tools Build Utilities – enu (11.1.21208.0). Everything you need to do a headless (i.e. without having Visual Studio installed) build/deploy of an SSDT database project.

So at the end of all that we have determined the following version numbers for SSDT database projects are:

Release

 

Visual Studio 2010

 

Visual Studio 2012

 

Visual Studio 2013

More

September 2012

 

10.3.20905.0

 

11.1.20905.0

 


November 2012

 

10.3.21101.1

 

11.1.21101.1

 


December 2012

 

10.3.21208.0

 

11.1.21208.0

 


June 2013

 

10.3.30618.1

 

11.1.30618.1

 


September 2013

 

10.3.30914.1

 

11.1.30914.1

 


October 2013

 

10.3.31009.2

 

11.1.31009.1

 


November 2013

 


 


 

12.0.30919.1

January 2014

 


 

11.1.32103.1

 


March 2014

 


 

11.1.40403.1

 

12.0.40403.0

SQL Server Data Tools for SQL Server 2014 is available

July 2014

 


 

11.1.40706.0

 

12.0.40706.0

SQL Server Data Tools July Update

I do not know the version numbers for the March 2012, September 2012 & November 2012 releases (if anyone out there does know please let me know in the comments) however I shall update this blog post for future releases. September 2012 and November 2012 releases now added!

I have requested that any blog post to announce future releases should contain the version numbers. Let’s hope that happens.

@Jamiet 

 

* DACFx is described here as:

The Microsoft® SQL Server® 2012 Data-Tier Application Framework (DACFx) is a component which provides application lifecycle services for database development and management for Microsoft® SQL Server® and Windows Azure SQL Databases.
DacFX supports various database deployment and management scenarios for SQL Server and Windows Azure SQL Databases including extracting/exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premise SQL Server to Windows Azure. This functionality is exposed via the DACFx managed API. DACFx can target SQL Server 2005 SP4, 2008 SP1, 2008R2, 2012, and Windows Azure SQL Databases. DACFx also provides the command-line utility SqlPackage.exe for creating and deploying .dacpac and .bacpac packages. DACFx supports scenarios provided by SQL Server client tooling including SQL Server Data Tools and SQL Server Management Studio 2012.

Published Friday, February 08, 2013 10:15 PM 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

 

Kyle Hale said:

Good info to know, two things:

1) Typo - "These *are* SSDT database projects, for Visual Studio 2012 & Visual Studio 2012 respectively." First one should be VS2010, natch.

2) The old version numbers, courtesy of James Serra's blog at SQLServerCentral:

http://www.sqlservercentral.com/blogs/jamesserra/2012/12/06/sql-server-data-tools-ssdt-november-2012-update/

February 8, 2013 6:56 PM
 

jamiet said:

Awesome, thanks Kyle. Now updated for both!

February 8, 2013 7:15 PM
 

Martin Cairns said:

It might be nice for the poor fools which install a borked latest version to include the download links for the previous version.  For the January 2014 version the download link is http://go.microsoft.com/fwlink/?LinkID=386302

April 4, 2014 11:50 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement