SQL Server Data Tools (SSDT)

QR Code – link to this page
All the following posts are in SSDT series on the blog:
- New DB project with SSDT and import existing database
- How to create DACPAC file?
- #TSQL2sDay β How SQLPackage.exe can spoil your deployment
- Tokenization of database project in SSDT
- SSDT (SqlPackage) thread crashes with error when publishing
- Script and deploy the data for database from SSDT project
- π¬ Deployment of Microsoft SQL database with Azure DevOps (video)
Code examples and courses:
- GitHub: SSDT Training – Free set of code examples database projects with SSDT
- Course: Projekty bazodanowe w SQL Server Data Tools SSDT (Polish edition)
- Course: Database projects with SSDT (English edition) – soon! Sign up for free materials (click banner below)
Useful Tools:
- SALT | GitHub – PowerShell module helps to deploy SQL Jobs in an incremental way
- DeploymentContributorFilterer – Use this tool to filter SQL objects during DACPAC deployment process by SqlPackage.exe.
Microsoft resources:
- π οΈ SQL Server Data Tools (MSDN)
- π οΈ SQLPackage.exe (MSDN)
- π οΈ Data-tier Application Framework (DACFx)
- Microsoft SQL Server Data Tools Team Blog
- GIT β branch organization
Other resources:
- Continuous Delivery and the Database (Redgate)
- π¬ SQL Toolbelt – Redgate’s tool for SQL Server databases CI/CD (Redgate)
- Database version control and deployment β model or migration scripts (Alex Yates)
- Version Control tools for SQL Server
Misc: