Last week at the SQL PASS SUMMIT 2011 in Seattle, Ted Kummert announced during his keynote that the final name of SQL Server Developers Tools code-named “Juneau” will be SQL Server Data Tools or SSDT for short. Additionally, the final name for SQL Server “Denali” will be SQL Server 2012.

SSDTLogo_thumbBesides the final name there were other important data points shared at the PASS Summit regarding SSDT:

  • SSDT will be broadly available as a free component of the SQL Server platform for all SQL Server users.
    • SSDT targets: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Azure
    • SSDT will update with releases of SQL Azure, which means every 4-6 months
  • SSDT will be initially released with SQL Server 2012
    • SSDT with SQL Server 2012 will be hosted in the Visual Studio 2010 SP1 shell. It will install standalone or combine with existing Visual Studio 2010 Professional SP1 or higher installations
  • SSDT will also ship with the next major release of Visual Studio
    • In the next major Visual Studio release, SSDT will replace and provide conversion capability for existing Visual Studio database projects
    • You can preview this change in the Microsoft® Visual Studio® 11 Developer Preview which was released at the //Build conference in September 2011
  • SSDT full versions and updates will be available online using the Web Platform Installer (WebPI)
    • SSDT installation will provide an administrative install experience to create a sharable setup which can be placed on a USB thumb drive or internal file share behind your firewall

For more information, check out the slides from our PASS Summit breakout session Database Development with SQL Server Data Tools Code-Named “Project Juneau” [AD-213-M].

So when can you get it?

Well you have to wait till SQL Server 2012 is released. The good news is that you can check out CTP3 today and we will provide updated bits in Q4 of CY2011 for you to evaluate. Watch the SSDT MSDN forum and the team blog for more details in the coming weeks.

Thanks,
Gert Drapers (@DataDude)
Principal Group Program Manager
SQL Server Data Tools (#SQLDataTools)

http://msdn.microsoft.com/data/tools