Managing Databases in Visual Studio with SQL Server Data Tools

SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise. SSDT facilitates sourced controlled schema and simplifies deployment. Additionally, features such as database unit tests, data compare and schema compare offer powerful capabilities for free.