November 21, 2011 | SQL Server, SQL Server 2012

SQL Server 2012 : The Data Tools installer is now available

Last week when RC0 was released, the updated installer for "Juneau" (SQL Server Data Tools) was not available. Depending on how you tried to get it, you either ended up on a blank search page, or a page offering the CTP3 bits. Important note: the CTP3 Juneau bits are not compatible with SQL Server 2012 RC0.

If you already have Visual Studio 2010 installed (meaning Standard/Pro/Premium/Ultimate), you will need to install Service Pack 1 before continuing. You can get to the installer simply by opening Visual Studio, going to File > New > Project, and then choose the option "SQL Server" that appears under the "Other Languages" category (not the "SQL Server" option that appears under the "Database" category):


When you click OK, you will get another dialog that prompts you to install SQL Server Data Tools:


When you click Install, your web browser will be launched on the Data Tools "Get Started" page. There you will see a link to "Download SQL Server Data Tools" which will launch or download SSDTSetup.exe:


At this point I would close Visual Studio 2010, because you'll probably be prompted to close it anyway.

As usual you'll be prompted with a security warning:


Next you'll need to agree to the lengthy license terms and conditions:


Next it will download LoaclDB (the new dev/Express runtime) and install. For me on multiple installs the Installation Progress bar held at 99% for a noticeable amount of time:


With a little bit of luck you should end up at the "Success" screen:


Now you can open Visual Studio directly (or from the "SQL Server Data Tools" menu item under All Programs > Microsoft SQL Server 2012 RC0. Choose File > New > Project and again choose "SQL Server" under "Other Languages." The option depicted above has changed to "SQL Server Database Project":

Click OK. You will find a Toolbox and a familiar Object Explorer on the left, where you can easily create new objects:


And now you can go to town developing your project. I haven't tried upgrading a project from CTP3 or from a previous version of "Data Dude." You're on your own there, sorry.

As an aside the "other" SQL Server option under "Database" contains all the old project types that you may not want to use anymore. I hope they straighten this out and consolidate by RTM:

If you already had Juneau CTP3 installed, you should be able to install SQL Server Data Tools CTP4 as an upgrade by simply downloading the updated SSDTSetup.exe from the "Get Started" page. You may still need to install Visual Studio 2010 Service Pack 1 prior to doing so. For what it's worth, I completely removed SQL Server 2012 CTP3 and Juneau CTP3 before attempting to install the updated bits. If you try an upgrade and come across any issues, please let me know.

You may be wondering why the versioning seems out of cadence – SQL Server is at RC0 while Juneau is at CTP4. This is because SQL Server is feature complete and an upgrade to RTM will now be supported. Juneau is not quite complete (there are still some pending changes before RTM); the naming remains CTP so that folks do not get the impression that an upgrade to RTM will be supported.

5 comments on this post

Comments are closed.