THE SQL Server Blog Spot on the Web

Welcome to - 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

Which version of SSDT Database Projects do I have installed?

I'm afraid I can no longer commit to keeping this page up to date given the rapid cadence of releases and the fact that I am no longer an active user of SSDT. If someone wishes to pick up the mantle please let me know and I shall link to your page.


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:


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


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:



Visual Studio 2010


Visual Studio 2012


Visual Studio 2013


Visual Studio 2015


September 2012






November 2012






December 2012






June 2013






September 2013






October 2013






November 2013





January 2014





March 2014








SQL Server Data Tools for SQL Server 2014 is available

July 2014








SQL Server Data Tools July Update

November 2014








SQL Server database tooling November update

February 2015







(not available at time of writing) 

SQL Server Data Tools and Data-Tier Application Framework Update for February 2015 

May 2015







(not available at time of writing) 

SQL Server Data Tools Update for May 2015 


Other versions spotted out in the wild include (but are not limited to):

  • 12.0.41012.0
  • 14.0.50325.0 (in VS2015 RC)

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.



* 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



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:

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

April 4, 2014 11:50 AM

Jacob Appleton said:

Just so you (and other readers) know, there's a new version out for February 2015.

Thanks for the blog post! I keep coming back to it because it's really useful.

March 12, 2015 1:51 PM

jamiet said:

Thanks Jacob. I've updated the table accordingly.

March 13, 2015 5:43 PM

David said:

The latest is now 11.1.50512.0 (checked 2015-05-28). I don't know when it was released, though.

May 28, 2015 8:33 AM

jamiet said:

Thanks for the heads-up David, now updated for the May 2015 release.

May 29, 2015 4:55 AM

Gregor said:

It seems that there is a new version for VS 2012 (and probably for VS 2013 and 2015 as well) 11.1.50730.0 (downloaded\installed 2015-09-14). I think that's the July-Release even if the SQL Server Data Tools Team Blog shows different numbers (11.0.50730.0)

September 14, 2015 12:21 PM

jamiet said:

Hi Gregor,

Yes, no doubt I have missed some. I can't commit to keeping it up to date these days I'm afraid.



September 14, 2015 4:26 PM

Jon_DevOps said:

Thanks for this site, it is awesome!

Why doesn't Microsoft provide this information?!!

September 21, 2015 11:12 AM

Eric Hutton said:

11.1.50730 with the June 2015 RTM version.

October 1, 2015 11:13 AM

Leave a Comment


This Blog


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