SSDT

SSDt, standing for SQL Server Data Tools, is a set of development tools integrated with Visual Studio that enables database development and the management of data-tier applications for Microsoft SQL Server and Azure SQL. It provides a project-based approach to building, versioning, and deploying database schemas and objects, rather than editing scripts ad hoc.

Core features include database projects (.sqlproj) for objects such as tables, views, stored procedures, and functions; schema and data comparison; deployment scripting; and packaging of database artifacts into DACPAC (Data-tier Application Package) files for versioned deployment. SSDt supports development against on-premises SQL Server, Azure SQL Database, and, in various configurations, Azure SQL Data Warehouse (Synapse). It integrates with source control and supports automated builds and deployments in continuous integration and continuous delivery workflows.

History and scope: SSDt was introduced as an extension to Visual Studio to enhance database development and has evolved with SQL Server versions and cloud offerings. It serves as a central toolset for database project management within the Visual Studio environment, complementing traditional database administration tools. Microsoft has also provided related tooling for business intelligence scenarios within the broader SSDt ecosystem, though exact packaging and emphasis have changed across releases.

See also: SQL Server, Visual Studio, DACPAC, Azure SQL Database, SQL Server Management Studio, Data-tier application.