How to handle migrations in production / CI/CD pipelines?

• Generate SQL script from tested migrations.
• Manually review and apply via DBA or DevOps tools.

Use EF Core tools in CI/CD (e.g., GitHub Actions, Azure DevOps):

dotnet ef database update --no-build

• Always backup the database before applying migrations in production.