What’s new? This update to the Data-Tier Application Framework (DACFx) addresses a high-priority issue causing potential data corruption during DAC Package creation. The issue is described below: Scenario/Issue Extracting a DACPAC with data or Exporting...

What’s new? This update to the Data-Tier Application Framework (DACFx) addresses several high-priority issues reported by DACFx and SQL Server Data Tools customers via the forum and Connect. The issues addressed include: Database Project in Visual Studio...

This post is important only if you need to open the same SQL Server unit test projects in both Visual Studio 2010 and Visual Studio 2012. The SQL Server unit testing runtime components installed with SQL Server Data Tools (SSDT) are specific to Visual...

The SSDT team is pleased to announce that SQL Server Data Tools - December 2012 is now available for download! Get it here: SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015 SSDT for Visual Studio 2010: http://msdn.microsoft...

The Windows Azure Import/Export Service powered by the SQL Server 2012 Data-Tier Application Framework (DACFx V3) provides a cloud service for logical backup/restore and migration of Windows Azure SQL Databases. This functionality is available via an...

SSDT now enables you to develop, debug and execute database unit tests interactively in Visual Studio, which can then be run from the command line or from a build machine, for example, a Team Foundation Build server configured for continuous integration...

What’s new? This release of the Data-Tier Application Framework (DACFx) brings fixes for several customer-reported and high-priority issues including: SSDT crashes when opening a table that contains specific computed column definitions from SQL Server...

We are pleased to announce that SSDT - November 2012 update is now available for download. Get it here SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015 SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014...

PASS Summit 2012 is just around the corner! If you’ll be at PASS next week, make sure to sync up with the SSDT team through one of the following avenues. We look forward to seeing you there. Booth SSDT members will be staffing the Optimization...

What’s new? This release of the Data-Tier Application Framework (DACFx) brings fixes for issues in earlier releases and several major updates. Many scenarios have been improved including those in other DACFx client tools such as SQL Server Data...

We recently released a new version of the DACFx runtime, DACFx (October 2012). This latest release brings with it several changes that affect compatibility between DACFx and SQL Server Data Tools (SSDT). Scenarios: User attempts to exercise DACFx functionality...

I’m pleased to announce the latest release of SSDT Power Tools! We continue to use power tools to get early versions of experiences or quick features to you and we’re always interested in hearing your feedback. This release of the tools (Version...

The SSDT team is pleased to announce that SQL Server Data Tools - September 2012 update is now available for download! Get it here : SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015 SSDT for Visual Studio 2010: http://msdn...

On Friday, September 14th, SQL Server Data Tools will release an update for both Visual Studio 2010 and Visual Studio 2012. SSDT functionality for both Visual Studio versions are completely in sync with this update, and database projects (.sqlproj) fully...

We are pleased to announce a new release of SQL Server Data-Tier Application Framework (DACFx)! What’s new? This September, 2012 release includes an update to SqlPackage.exe where the following scenarios have been enabled for packaging...

This post demonstrates two methods for managing database changes in source control with SQL Server Data Tools. The standard integration that you would find with any project type in Visual Studio is all there for SSDT Database Projects, but C# developers...

Several questions have been raised on the forum regarding use of composite projects. This post discusses composite projects in general and then describes a technique you can use with Schema Compare for synchronizing composite projects with changes that...

If you're attending TechEd North America this week, make sure to sync up with the SSDT team! Team members will be staffing a Cloud on Your Terms demo station in the Exhibition Hall, where we'll be available to discuss SSDT and answer any questions you...

Since the release of Visual Studio 2012 RC , the SQL Server Data Tools team has become aware of several reports of SSDT no longer working when machines are upgraded from Visual Studio 2012 Beta to Visual Studio 2012 RC. As a follow up to our investigation...

LocalDB Basics LocalDB is a version of SQL Server Express created specifically for developers. If you’re new to LocalDB, the Introducing LocalDB blog post is a great starting point to learn more but in summary, LocalDB is a fast, lightweight...

I’m pleased to announce the latest release of SSDT Power Tools . As noted previously we are using power tools to get early versions of experiences to you because we’re interested in hearing your feedback. This release of the tools builds on...

With current interest in cloud computing, migration to SQL Azure is a hot topic. Migrating a database to the cloud is a significant undertaking, with many architectural challenges to be considered. High among these is that some features of SQL Server...

I am pleased to announce the first release of SSDT Power Tools . The SSDT team will be leveraging Power Tools as a mechanism to deliver new functionality and experiences through frequent updates, of which this is the first example. In this first iteration...

Schema Compare is an incredibly useful tool, providing a visual head over SSDT’s model differencing and update engine. It can be used to compare any combination of database, project or dacpac, and allows selective update of the target schema (via...

With the release of SSDT RTW, it is no longer required to remove previous installations of SSDT before upgrading to a newer release. This means that if you have CTP4 or CTP4 Update 1 on your machine and you wish to upgrade to RTW, you can install RTW...