It moves database development from an imperative, script-based, error-prone process to a declarative, source-controlled, testable discipline.
Your entire schema lives in Git. You can branch, diff, merge, and roll back database changes like application code. what is ssdt
Here's a step-by-step overview of how SSDT works: error-prone process to a declarative