Right within the IDE, you can use version control for all of the files if you are working in a team-based environment. SSDT includes a visual Table Designer for creating and editing tables in either database projects or connected SQL Server instances. Developers can create a SQL Server Database Project in the SSDT and without being connected to any live SQL Server instance they can design and develop their database code. SSDT provides the capability to use Visual Studio IDE itself for database design, development, debugging and testing for developers with limited or no access to a live (production) database. Getting Started with SQL Server Data Tool (SSDT) – Disconnected Mode SSDT provides the ability to the database developer to build, debug, maintain and refactor database objects in a simple and interactive way. SSDT provides writing database code in both connected (either on or off-premise) as well as in disconnected mode and the best part is the experience is seamless while working in either any of these modes.

Once having installed SQL Server Data Tool, a developer no longer needs to have SQL Server Management Studio (SSMS), which is primarily intended for managing SQL Server and database instances, for database development and design activities. SQL Server Data Tool (SSDT) is a new feature in SQL Server 2012 and a free web platform installer, which can be installed from here for Visual Studio 2010 and from here for Visual Studio 2012. Introduction to SQL Server Data Tool (SSDT) SQL Server Data Tool (SSDT) is a new feature in SQL Server 2012 that provides this capability primarily intended for developers and lets developers write their application as well as database code in a single development environment of Visual Studio.

As developers, we have always wanted to have a single Integrated Development Environment (IDE) for not only writing application code but to also to write database code in a single place without switching the environments.

Ssdt visual studio