How should EF Core migrations be designed for production in Entity Framework Core?

Review generated SQL, test on production-like data, use backward-compatible rollout patterns, and back up critical data. The implementation should be justified by measurable requirements, kept as simple as the problem allows, and validated with realistic tests, telemetry, failure handling, and documented tradeoffs.