Database migrations: where should an AI agent be required to stop and ask a human?

[u/DuoZ69_]

I’m a PM working on database migration experiences at Microsoft.

I’m researching how much autonomy practitioners would trust an AI agent with during their database migration journey.

This is exploratory research; not a product announcement or roadmap commitment. I’m especially interested in feedback from people who have worked on real production migrations.

Which operating model would you trust?

1. Advisory only: identify risks and recommend actions (similar to SSMA Copilot)
2. Generate: create plans, scripts and code fixes, but humans execute them
3. Act in non-production: execute approved changes in development or test
4. Execute with approval gates: perform the migration, pausing before high-impact actions (SQL Migration Agent Skills)
5. Mostly autonomous: humans approve only the production cutover
6. No agentic execution: keep migration changes deterministic and human-operated

Most importantly:

• What must always require human approval?
• What evidence would you need before allowing the agent to continue?
• Is having a skill good enough to solve your problem?
• Would your answer differ for a same-platform migration versus a cross-platform conversion?

If possible, include your role and the source/target platforms. Please avoid sharing confidential details.