SQL Server Data Tools

Overview

SQL Server Data Tools (SSDT) is an integrated development environment for building SQL Server relational databases, Azure SQL databases, Integration Services packages, Reporting Services reports, and Analysis Services data models.

Key Concepts

• Project Types: Database, Data-tier Application, Analysis Services, Integration Services, Reporting Services.
• Schema Compare: Compare and synchronize database schemas.
• Data Compare: Identify differences in data across databases.
• Refactoring: Rename tables, columns, and objects safely.

Supported Platforms

SSDT works with Visual Studio 2019, 2022 and later, and supports SQL Server 2008 R2 through SQL Server 2022 as well as Azure SQL Database.

Resources

Explore the following resources to deepen your knowledge:

• Download SSDT
• Getting Started Guide
• Step‑by‑Step Tutorials
• API Reference

Sample Project Structure

MyDatabaseProject/
│   MyDatabase.sqlproj
│   readme.md
├───Schema
│   ├───Tables
│   │   └───dbo.Customer.sql
│   ├───Views
│   │   └───dbo.CustomerView.sql
│   └───StoredProcedures
│       └───dbo.GetCustomer.sql
└───Scripts
    └───PostDeployment.sql