A collection of articles covering SQL source control and Database version control tool topics
Commit SQL Server database objects
- Getting a database under version control: How to link a database to source control and initially commit objects
- How to commit database objects to SQL Server database Source control
- How to use source control with SQL Server Management Studio (SSMS)
- Integrate source control with SQL Server to reduce database development time
- Three phased approaches to getting your SQL Server database into source control
- SQL Server database continuous integration workflow COMMIT step – Initially committing a SQL database to a source control repository
- SQL Server Source control – Part I – understanding source control basics
- SQL Server Source control – Part II – Integration
- Synchronize SQL database changes between local and remote repositories in distributed source control systems
- SQL Server database continuous integration workflow BUILD step – Building a SQL database from a source control repository
Version control history
- How to see the full version history of a SQL Server database object under source control and, if needed, revert changes
- Revision history of an object change in a SQL database using Git
- “What broke my database?” Using SQL database source control for forensic auditing and database troubleshooting
- SQL Server true detective – Solving the case of the broken database
Implement development models
- How to implement SQL Server source control using the dedicated development model
- How to implement SQL Server source control using the shared development model
Implement database policies
- How to implement check out and lock policies in the shared database source control development model
Manage static data
- How to link and initially commit SQL Server database static data
- How to manage version controlled SQL Server database static data; from commit to usage, to deployment
- How to pull version controlled SQL Server database static data from a repository
- How to work with version-controlled SQL Server database static data
Work with branches
- How to maintain SQL database changes working with Git branches
- How to make SQL database version control safer with branches
Version control labels (tags)
Track database changes
- Using SQL source control to track database changes
- How to version control SQL scripts alongside SQL database objects
- How to update a SQL database from source control while avoiding dependency errors
- How to keep a source control repository updated with the latest SQL Server database changes
Define database changes
