Why version control your SQL Server database?
- to know who changed what, when and why
- to achieve repeatable and automated database deployments
What does DB Version Control do?
- tracks database changes and generates migrations (change scripts) automatically for both schema objects and static data
- scripts schema objects and static data into individual files for change tracking
How to version control your SQL Server database?
- use DB Version Control to generate migrations and script objects to files
- use any version control system (GIT, TFS, SVN) to keep track of generated database files
- use Migration runner to deploy database changes
Tutorials
-
Working with Azure SQL Databases
-
Versioning static data
-
Multi-environment project setup
-
Using Branches while developing the database
-
Working with a team while making changes to the versioned database
-
Deploying changes from scripted database files
-
Record changes to the database that is being version controlled
-
Version control an existing database - getting started