BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

Visual Studio Gets Better SQL Server Tooling – ‘Juneau’

by Roopesh Shenoy on Jul 30, 2011 |

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.

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

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT