Search results matching tags 'SQL Server 2012', 'denali', and 'juneau'

SQL Server 2012 : The Data Tools installer is now available

AaronBertrand — Mon, 21 Nov 2011 15:18:00 GMT

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.

Confirmed: Juneau is in the next version of Visual Studio

jamiet — Tue, 20 Sep 2011 21:32:00 GMT

Its no great secret that Juneau, a collection of features in the forthcoming SQL Server codenamed Denali, will be in the next version of Visual Studio but its nice to have it confirmed all the same. I have installed the first publicly available drop of that next version (known as Visual Studio 11 Developer Preview, download from here) that was released at last week's BUILD event and sure enough the Juneau stuff is right there. Here’s some screenshots:

Note the presence of Juneau in the About dialog:

Here’s the new Juneau table designer:

OK, so this isn’t really news (unless you didn’t already know about it) however what is of interest is that this is the Express Edition of Visual Studio. This bodes well for full release – Juneau needs to be available to as many folks as possible which means not making it exclusive to the Ultimate Edition.

@jamiet

SQL Server Development Tools Advisory Program

jamiet — Wed, 13 Apr 2011 21:16:06 GMT

You may have heard that the next version of SQL Server (code-named Denali) will include a new tool (code-named Juneau) that is intended to bring a first-class development experience for T-SQL developers. Juneau is not yet available for us, the general public, to try out so in an attempt to get some early feedback Microsoft have launched the “SQL Server Development Tools Advisory Program” – participants will get access to Juneau releases out-of-band from forthcoming CTPs. From the announcement by Ed Hickey:

Are you a TSQL developer interested in developing database projects for SQL Server Code-Named “Denali” and SQL Azure? Do you want access to the SQL Server Developer Tools, Code-Named “Juneau” (SSDT) engineering team and influence the design of our product going forward? If so, checkout the SSDT Advisory program!

Microsoft is busy preparing the release of SQL Server Developer Tools, Code Name “Juneau”. This exciting new tool will include improvements that are interesting to database developers who are building solutions for both on and off premise databases. Planned features include the following,

Create and edit entities in both connected database instances and offline database projects using a brand new table designer.

A single project type for all supported database server platforms, and instant platform validation for scripts.

Improved TSQL editor with code navigation, IntelliSense, language support that parallels what is available for C# and VB, platform specific validation, debugging and declarative editing.

These are just a few improvement categories that have been discussed publically. There are many more that will be revealed as we move forward.

We are actively seeking TSQL developers who are interested in evaluating all the cool ideas we are toying with. It’s easy to self-nominate, all you need is a Windows Live ID and a non-disclosure agreement with Microsoft. You will be asked to provide some details about your company and your latest database projects for evaluation.

The Advisory program lasts for 6 months. Program participants will have access to SSDT product prototypes in videos and pictures every month, and participate in surveys to give us feedback on the new ideas we are showing.

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/5ee377ef-f24c-4162-97e2-811ab4eb180f

(emphasis is mine)

If you’re interested in getting involved hit the link above and sign-up!

@Jamiet