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.
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 firstname.lastname@example.org.