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)

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:

• 👉 Who to follow on Twitter