Microsoft Certified: DevOps Engineer ExpertDesign and implement pipelinesMedium
A global e-commerce company uses Azure DevOps to manage its release pipelines for a critical inventory management system. The system relies on a complex SQL database. New releases frequently involve database schema changes that must be applied in a controlled and reversible manner. The DevOps team needs to ensure that schema migrations are automatically executed as part of the release pipeline and are fully trackable. Which tool or approach should the team integrate into their Azure DevOps release pipeline to address these requirements?
- AImplement custom PowerShell scripts to apply schema changes directly.
- BIntegrate a database migration tool like Flyway or Redgate SQL Change Automation.
- CManually execute SQL scripts via Azure Data Studio.
- DUse Azure SQL Database's built-in import/export service.
Show answer & explanationAnswer & explanation
Correct answer: B. Integrate a database migration tool like Flyway or Redgate SQL Change Automation.
Dedicated database migration tools like Flyway, Redgate SQL Change Automation, or Liquibase are designed for managing schema changes in a controlled, versioned, and reversible manner. They integrate well with CI/CD pipelines, providing automation and trackability for database deployments.
Why the other options are wrong
- A. Custom scripts can be error-prone, hard to maintain, and lack the advanced features (versioning, rollback) of specialized tools.
- C. Manual execution is prone to errors, lacks automation, and is not trackable within the pipeline.
- D. Import/export services are for data movement or full database copies, not for incremental schema migrations.
Database Schema Migration Tools
Tools designed to manage and automate incremental changes to database schemas in a version-controlled and reversible manner.
- Automate schema updates as part of CI/CD.
- Provide version control for database schema.
- Support rollback capabilities for failed deployments.
Memory trick: Migrate schemas with systematic tools.