SQL Server Data Tools (SSDT) Description
SQL Server Data Tools (SSDT), transforms database development by introducing an ubiquitous declarative model that spans all phases of database development within Visual Studio. To build, debug, maintain and refactor databases, you can use SSDT TransactSQL design capabilities. You can work directly with a connected database instance, or with a database project. Developers can use familiar Visual Studio tools for database development. Tools include code navigation, IntelliSense and language support that is similar to what is available for Visual Basic and C#. Also, platform-specific validation and debugging are possible. Declavicive editing can be done in Transact-SQL. SSDT also offers a visual Table Designer that allows you to create and edit tables in any of your database projects or connected databases. Version control can be used to manage all files while you work on your database projects in a group-based environment.