SQL Server Data Tools (SSDT) introduces an ubiquitous, declarative model that spans all the phases of database development and maintenance/update inside Visual Studio. The developer can use SSDT TSQL design capabilities to build, debug, maintain and refactor databases whether working with a database project, or directly with a connected database instance located on or off-premise.
SQL Server Data Tools (SSDT) introduces an ubiquitous, declarative model that spans all the phases of database development and maintenance/update inside Visual Studio. The developer can use SSDT TSQL design capabilities to build, debug, maintain and refactor databases whether working with a database project, or directly with a connected database instance located on or off-premise.
With SSDT developers can use familiar Visual Studio tools for database development, such as: 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. SSDT also provides a visual Table Designer for creating and editing tables in either database projects or connected database instances.
While working on database projects in a team-based environment, developers can use version control for all the files. When it’s time to publish the project, developers can publish to all supported SQL platforms; including SQL Azure and Microsoft SQL Server 2012. SSDT platform validation capability ensures that your scripts will work on the target you specify.
SSDT also includes special project types and tools for developing SQL Server 2012 Analysis Services, Reporting Services, and Integration Services Business Intelligence (BI) solutions (formerly known as Business Intelligence Development Studio).
