BT

Your opinion matters! Please fill in the InfoQ Survey!

Visual Studio Gets Better SQL Server Tooling – ‘Juneau’

| by Roopesh Shenoy Follow 0 Followers on Jul 30, 2011. Estimated reading time: 1 minute |

SQL Server Development Tools (SSDT) - ‘Juneau’ - brings testing, debugging, version control, refactoring, dependency checking, and deployment to database development in Visual Studio. It was previewed recently along with SQL Server ‘Denali’ CTP.

Some of the features in the preview are -  

  • New Testing and Debugging method which works with a local database that’s created automatically for each database project
  • Schema Compare – for comparing a SQL Server Project Schema to a target database and highlight differences
  • Publish Database feature, that supports both onsite SQL Server as well as SQL Azure
  • Declarative database development through Power Buffer
  • Enhanced TSQL editor with features like IntelliSense, Go To Definition and Find All References, Refactor contextual menu and more, similar to C# and VB editors in Visual Studio

There is a blog post from the SSDT team that outlines all the planned features in SSDT - one major feature missing in the preview is the Application Project and Database Integration, which is meant to give build-time dependency checking between Application and Database tiers. The preview also misses quite a few features present in Visual Studio Database Projects as noted by Milo Hoffman. Some of these missing features might eventually get added before SSDT is actually released.

Although the preview works with Visual Studio 2010, SSDT will finally ship with the next version of Visual Studio. It will also be available as a standalone version using the Visual Studio Shell.

You can find more information about Juneau and download the preview from the product website.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT