Data Driver

Blog archive

SQL Server Data Tools Updated for Visual Studio 2012

Microsoft recently updated SQL Server Data Tools (SSDT) with support for Visual Studio 2012, improved LocalDB functionality and new SSDT Power Tools.

SSDT, if you're unfamiliar with it, is a hodgepodge of functionalities targeted at easier database project development from within Visual Studio. For example, one main feature is that data devs no longer have to switch back and forth between SQL Server Management Studio and Visual Studio, working entirely in the latter.

The September 2012 update comes in versions for Visual Studio 2012 and Visual Studio 2010. The big news, of course, is that SSDT now plays nicely with Visual Studio 2012. I wrote earlier about the problems users (including me) were having getting the two to work together. "This release of SSDT supports the Visual Studio 2012 shell," wrote Janet Yeilding in the team blog post announcing the update. "SSDT September 2012 contains several bug fixes to the SSDT version that shipped in Visual Studio 2012 and this release can be applied as an update on top of Visual Studio 2012 Professional, Premium, and Ultimate Editions.

The new SSDT release also includes configuration improvements for LocalDB, a streamlined, simplified version of SQL Express that speeds up data development by obviating the need for developers to set up full SQL Express instances on their machines. "We received feedback that SSDT's policy of creating a new LocalDB instance for each SSDT solution was too verbose, so we created a single LocalDB instance called Projects to host all the project debug databases," Yeilding said. "We've also enhanced SQL Server Object Explorer by surfacing the default LocalDB instance and enabling the deletion of LocalDB instances."

Other improvements include an updated Data-Tier Application Framework, support for non-standard ANSI_NULLs and QUOTED_IDENTIFIER properties, numerous bug fixes and new companion SSDT Power Tools.

The new SSDT Power Tools release, which works only with the new SSDT main release, also offers brand-new support for Visual Studio 2012. "For the first time, this Power Tools release provides a version of the power tools for Visual Studio 2012 in addition to the version for Visual Studio 2010," the team blog said. The new Power Tools come in separate installations for Visual Studio 2012 and Visual Studio 2010.

Besides the Visual Studio 2012 compatibility, the new Power Tools release has new functionality allowing the creation and deployment of Data-Tier Applications (*.dacpacs files), described in the blog post as "the core artifact of the DAC Framework."

Posted by David Ramel on 09/26/2012 at 9:51 AM


comments powered by Disqus

Featured

  • Telerik UI for Blazor Updated

    Progress announced an update to its Telerik UI for Blazor components, targeting Microsoft's open source Blazor framework that lets C# coders create web apps without having to rely upon JavaScript.

  • Infragistics Unveils UI Components for Blazor

    Infragistics, specializing in third-party UI/UX controls and tools, unveiled a new offering targeting Blazor, Microsoft's red-hot open source framework that allows for C#-based web development instead of traditional mainstay JavaScript.

  • AWS Open Sources Tool for Porting .NET Framework Apps to .NET Core

    Leading cloud computing platform Amazon Web Services open sourced the it announced in July for helping users port old .NET Framework applications to the new .NET Core framework.

  • Uno Platform Ports Windows Calculator to Linux

    Uno Platform has ported the famed Windows Calculator, open sourced last year, to Linux as part of a continuing "proof point" effort to demonstrate the reach of what it describes as the sole UI offering available to target Windows, WebAssembly, iOS, macOS, Android and Linux with single-codebase applications coded in C# and XAML.

  • ASP.NET Core OData 8 Preview Supports .NET 5, but with Breaking Changes

    ASP.NET Core OData, which debuted in July 2018, is out in a v8.0 preview that for the first time supports the upcoming .NET 5 milestone release.

Upcoming Events