Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio.
Database developers will be able to rely on the SQL Server Object Explorer in Visual Sudio to generate or modify database objects and data, as well as execute queries.
Developers will also appreciate the familiar VS tools we bring to database development, specifically; code navigation, IntelliSense, language support that parallels what is available for C# and VB, platform-specific validation, debugging and declarative editing in the TSQL Editor, as well as a visual Table Designer for both database projects and online database instances.
· Visual Sudio
What's New in This Release: [ read full changelog ]
SQL Server Object Explorer:
· In this release, we’ve introduced the SQL Server Object Explorer (SSOX)! This is SSDT’s new very own tool window in Visual Studio. The object hierarchy in SSOX has a very similar appearance and navigation style as SSMS. This is deliberate as we wanted to provide you with a familiar environment in which you can retain some of your memory muscle and best practices.This view is server-centric, focusing on connections at the server level rather than at the data source level, allowing SSOX to serve as the command-center for a variety of development activities.
T-SQL Editor Usability Improvements:
· As a result of some strong feedback, we have worked to clean up the T-SQL editing experience and provide cleaner, more intuitive toolbars and menus. Focus has been put on ease of use and discoverability for core tasks in each T-SQL editing scenario. For connected T-SQL script execution, the toolbar now includes only those commands relevant to imperative scripting ...