Security Tightened in SQL Server Data Tools Update

Database schema comparisons, security among incremental updates made to this July 2014 release of SSDT.

The Microsoft SQL Server team has made incremental updates to SQL Server Data Tools (SSDT), updating the Schema Compare utility, improving Microsoft Azure SQL Database security and supporting Parallel Data Warehouse. The July 2014 release is available from the Data Developer Center.

Schema Compare, a utility used for comparing data definitions between connected databases, has been updated so that it now can be used natively within MSBuild, the Visual Studio build platform. Schema Compare output within build can be output via text or XML. A more detailed description of the integration of Schema Compare in MSBuild is in this blog post.

Improvements were also made to the Microsoft Azure SQL Database node, with the addition of Visual Studio 2012 support, as well as a new security feature that allows use of token-based authentication via a Microsoft account or OrgID.

For those using SQL Server Parallel Data Warehouse (PDW) appliances, SSDT also adds support for PDW tooling in Visual Studio Express 2013 for Windows Desktop. PDW appliances have been updated to support Visual Studio versions 2012 and 2013.

About the Author

You Tell 'Em, Readers: If you've read this far, know that Michael Domingo, Visual Studio Magazine Editor in Chief, is here to serve you, dear readers, and wants to get you the information you so richly deserve. What news, content, topics, issues do you want to see covered in Visual Studio Magazine? He's listening at [email protected].

comments powered by Disqus


  • Black White Wave IMage

    Neural Regression Using PyTorch: Training

    The goal of a regression problem is to predict a single numeric value, for example, predicting the annual revenue of a new restaurant based on variables such as menu prices, number of tables, location and so on.

  • Microsoft Ships Visual Studio 2019 v16.9 Servicing Baseline Release

    Microsoft is urging enterprises and professional coders to standardize on the new Visual Studio 2019 v16.9, a servicing baseline release that's guaranteed to receive official support for an extended period.

  • Microsoft Extends Low-Code Push with Power Fx Programming Language

    "Using formulas that are already familiar to hundreds of millions of users, Power Fx allows a broad range of people to bring skills they already know to low code solutions."

  • Microsoft's Tools to Fight Solorigate Attack Are Now Open Source

    Microsoft open sourced homegrown tools it used to check its systems for code related to the recent massive breach of supply chains that the company has named Solorigate.

Upcoming Events