This project demonstrates how to implement modern database DevOps practices using SQL Server Database Projects (SSDT), DACPAC, and CI/CD pipelines.
Traditional database deployments rely on manual scripts and are prone to errors.
This project shows how to:
- Treat database schema as source-controlled code
- Automatically build and validate schema changes
- Enable repeatable and reliable deployments using DACPAC
Developer → Git → CI Pipeline → DACPAC → Target Database
- SQL Server
- Visual Studio Community (SSDT)
- DACPAC (Data-tier Application Package)
- Azure DevOps Pipelines
- Git / GitHub
- PowerShell
- Database schema is defined in the SQL project
- Changes are committed to source control (Git)
- CI pipeline builds the project into a DACPAC
- DACPAC can be deployed to target environments
- Schema changes are applied in a consistent, repeatable way
Traditional database deployments are:
- Manual
- Error-prone
- Hard to track
This project demonstrates how to:
- Automate database builds
- Improve deployment reliability
- Reduce risk in production changes
- Enable DevOps practices for databases
- Add full CI/CD pipeline execution
- Implement automated deployments (CD)
- Add environment-specific configurations
- Integrate database testing
- Expand schema with additional objects
This is a personal learning project and does not contain any proprietary or production data.