SQL Server Data Tools and Data-Tier Application Framework Update for February 2015

The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools in Visual Studio and the Data-tier Application Framework (DACFX) is now available.

Get it here:

SQL Server Data Tools: https://msdn.microsoft.com/data/hh297027

Data-Tier Application Framework (DACFX): http://www.microsoft.com/en-us/download/details.aspx?id=45886

What’s New?

Support for the latest Azure SQL Database V12 features

Many features were added to Azure SQL Database in V12, and now the developer tools in Visual Studio support V12.

Improved Cross-Platform Schema Comparison

Schema compare has required you to select the “allow incompatible platforms” option when comparing a source to a target that supports fewer objects, as when the source is SQL Server 2014 and the target is SQL Server 2008. Now you can compare anything without selecting the “allow incompatible platforms” option. If any compatibility issues exist, you’ll be notified when you attempt to update the target. Note, though, that incompatible DML, such as procedure bodies, won’t be identified. Look for that feature in a future release.

New advanced publish options

We’ve added new options to increase your control over publishing, including the ability to not drop users. For more details, click here.

Note: A known issue exists in this release with the deployment options configuration for debug deployment. This dialog is accessed through the Project Properties > Debug page by clicking the button labeled Advanced. On that dialog, the new Do Not Drop options are not displayed, but should be. This will be corrected in the next update of SQL Server Data Tools.

Bug fixes to customer-reported issues

This release includes fixes for the following issues:

Contact Us

If you have any questions or feedback, please visit our forum or Microsoft Connect page.  We look forward to hearing from you.