SQL Server Database Tooling Preview Release for the latest Azure SQL Database Update V12 (preview)

We are excited to announce the release of the Preview of Microsoft® SQL Server Database Tooling in Visual Studio and Microsoft® Data-Tier Application Framework Preview for the latest Azure SQL Database Update V12 (preview). Note that this preview is only available for English versions of Visual Studio 2013. As a pre-release version, this preview may… Read more

SQL Server database tooling November update

We’d like to announce the availability of the latest November 2014 release of SQL Server database tooling for Visual Studio. This update is now available for Visual Studio 2012 and 2013. For Visual Studio 2012 use the “SQL –> Check for Updates” tool inside Visual Studio. For Visual Studio 2013 download check the Visual Studio… Read more

Presentation on Visual Studio Database Projects Integration with Visual Studio Team Foundation Server

This post contains the slide deck from a recent presentation on how to integrate Visual Studio Database Projects with Visual Studio Team Foundation Server. We have also recently published an accompanying blog with extended content, details and scenarios: http://blogs.msdn.com/b/ssdt/archive/2014/07/24/sql-server-database-projects-and-team-foundation-build.aspx.  (Note: A link to the complete slide deck can be found at the bottom of the… Read more

SQL Server Database Projects and Team Foundation Build

This post provides walkthroughs that discuss the use of SQL Server Database Projects (.sqlproj files) with Team Foundation Build in Team Foundation Server 2013. The scenarios addressed are: Configuring a Build Configuring a Build with Unit Tests Automatically Publishing a Database Project after a Successful Build Automatically Publishing a Database Project that includes Deployment Contributors… Read more

Creating an administrative install of SSDT update for Visual Studio 2013

Since we are offering our VS2013 update via the Visual Studio update channel, there aren’t any specific instructions on how to get the download if you need to create an administrative layout.  You may need to do this if your firewall or proxy settings do not allow some computers to access the download center. You… Read more

MSBuild support for Schema Compare is available

Schema compare is one of the most important Visual Studio SQL Server tooling components. As of our July release the schema compare functionality is available via MSBuild. It can be run from the command line or as an integrated part of automated project build systems to detect changes and generate reports. Supported versions SQL Server… Read more

SQL Server Data Tools July Update

We’d like to announce the availability of the latest July 2014 release of SSDT. This update is now available for Visual Studio 2012 and 2013. For Visual Studio 2012 use the “SQL –> Check for Updates” tool inside Visual Studio or download via the download link below. For Visual Studio 2013 download check the Visual… Read more

Developing Enterprise SQL Server Features in Visual Studio database tooling

SQL Server 2014 introduced a number of new enterprise features. The most notable of these are memory optimized tables and natively compiled stored procedures. When developing databases with enterprise features in Visual Studio there are a few best practices to be aware of. Debugging enterprise features We encourage users to apply multiple levels of validation… Read more

SQL Server Data Tools for SQL Server 2014 is available

We’d like to announce the availability of the latest March 2014 release of SSDT with support for SQL Server 2014 databases. This version is fully compatible with SQL Server 2014. This update is now available for Visual Studio 2012 and 2013. For Visual Studio 2012 use the “SQL –> Check for Updates” tool inside Visual… Read more

SSDT and Visual Studio versions

Hello all, there have been some questions around our support for various Visual Studio versions and the update mechanism for them.  I hope this will help clarify some of the questions: Visual Studio 2013 – VS 2013 now has SQL Server tooling built in and shipped as part of the core product.  Database Projects, SQL… Read more