SSDT Methodologies for SQL Server DevOps

Eitan Blumin

Implementing DevOps methodologies with databases is not an easy task, and it becomes even more difficult when the DBAs in charge of development are not experienced with the world of Agile, DevOps, CI/CD, Change Automation, Development Lifecycles, and more scary-but-cool-sounding words.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD – SSDT has it all – and it’s completely free!

In this session, you will learn the methodologies and best practices of working with database development lifecycles and change automation (specifically using SSDT), understand the differences between state-based and migration-based deployments, learn how to strategically tackle common edge cases, and more.

Get the Latest

Sign up to stay up to date with news, special announcements and educational content.

Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.