A collection of articles covering DevOps, continuous integration and continuous delivery topics
General
- Why is database continuous integration and delivery so hard and how to make it easy; SQL Server database DevOps pain points and solutions
- What is SQL Server database continuous integration (CI)? – a high level conceptual overview and walk thru of the steps in a SQL database CI pipeline
Commit objects to source control
- How to commit database objects to SQL Server database Source control
- SQL Server database continuous integration workflow COMMIT step – Initially committing a SQL database to a source control repository
Build a database from source control
- How to automatically build a database from SQL Server source control
- SQL Server database continuous integration workflow BUILD step – Building a SQL database from a source control repository
Synthetic data generation
- How to automatically create synthetic test data for a SQL Server database
- SQL Server database continuous integration workflow POPULATE step – Populating the newly built SQL database with data
Unit test execution
- How to automatically process SQL Server databases with Unit tests
- SQL Server database continuous integration workflow TEST step – Running SQL unit tests against the changes
Audit SQL Server database for changes
SQL server database documenting
SQL Server database comparison and synchronization
- Automatically comparing and synchronizing data changes in a SQL Server database
- Automatically comparing and synchronizing SQL Server database schema changes
- SQL Server database continuous integration workflow SYNC step – Creating the synchronization/migration script
- Automating database synchronization using a continuous integration solution
Initiate CI/CD process on commit
