When it's time to publish your project, you can publish to all supported SQL platforms including SQL Database and SQL Server. While you are working on your database projects in a team-based environment, you can use version control for all the files. SSDT also provides a visual Table Designer for creating and editing tables in either database projects or connected database instances.

Tools such as: code navigation, IntelliSense, language support that parallels what is available for C# and Visual Basic, platform-specific validation, debugging, and declarative editing in the Transact-SQL editor.

You can work with a database project, or directly with a connected database instance on or off-premise.ĭevelopers can use familiar Visual Studio tools for database development. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. 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.

Mac excel 2013 data tools relationships