Azure database migration

Azure Database Migration service Skill

This skill provides expert guidance for Azure Database Migration service. Covers troubleshooting, decision making, limits & quotas, security, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.

How to Use This Skill

IMPORTANT for Agent: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., L35-L120), use read_file with the specified lines. For categories with file links (e.g., [security.md](security.md)), use read_file on the linked reference file

IMPORTANT for Agent: If metadata.generated_at is more than 3 months old, suggest the user pull the latest version from the repository. If mcp_microsoftdocs tools are not available, suggest the user install it: Installation Guide

This skill requires network access to fetch documentation content:

• Preferred: Use mcp_microsoftdocs:microsoft_docs_fetch with query string from=learn-agent-skill. Returns Markdown.
• Fallback: Use fetch_webpage with query string from=learn-agent-skill&accept=text/markdown. Returns Markdown.

Category Index

Category	Lines	Description
Troubleshooting	L34-L41	Diagnosing and fixing common Azure DMS issues, including classic vs new DMS problems, MySQL migration errors, and source database connectivity and network failures.
Decision Making	L42-L47	Choosing the right Azure DMS tool and scenario for your source/target databases, plus FAQs on supported migrations, limitations, and how to use Azure Database Migration Service.
Limits & Quotas	L48-L55	Migration-specific limits, unsupported features, and constraints when using Azure DMS to move MySQL, PostgreSQL, SQL Managed Instance, MongoDB, and hybrid deployments.
Security	L56-L61	Security guidance for Azure DMS migrations, including SQL best practices (network, auth, encryption) and configuring custom RBAC roles for MySQL migration scenarios.
Integrations & Coding Patterns	L62-L66	Automating MySQL-to-Azure Database for MySQL migrations using Azure Database Migration Service with PowerShell scripts, parameters, and end-to-end workflow examples.
Deployment	L67-L71	Using Azure DMS to redeploy or migrate SSIS packages to Azure SQL Database or SQL Managed Instance, including configuration steps and migration considerations.

Troubleshooting

Topic	URL
Resolve common Azure Database Migration Service issues	https://learn.microsoft.com/en-us/azure/dms/faq
Resolve known issues migrating to Azure MySQL	https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-mysql-fs-online
Troubleshoot common Azure DMS classic migration issues	https://learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms
Fix Azure DMS source database connectivity problems	https://learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms-source-connectivity

Decision Making

Topic	URL
Choose database migration tools with the Azure DMS matrix	https://learn.microsoft.com/en-us/azure/dms/dms-tools-matrix
Select supported Azure DMS migration scenarios	https://learn.microsoft.com/en-us/azure/dms/resource-scenario-status

Limits & Quotas

Topic	URL
Review online PostgreSQL to Azure Database for PostgreSQL migration limitations	https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-postgresql-online
Review online migration limits to Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online
Understand Azure DMS hybrid mode limitations and issues	https://learn.microsoft.com/en-us/azure/dms/known-issues-dms-hybrid-mode
Review MongoDB to Azure Cosmos DB migration limitations with DMS	https://learn.microsoft.com/en-us/azure/dms/known-issues-mongo-cosmos-db

Security

Topic	URL
Apply security best practices for DMS SQL migrations	https://learn.microsoft.com/en-us/azure/dms/dms-security-best-practices
Configure custom RBAC roles for MySQL migrations in DMS	https://learn.microsoft.com/en-us/azure/dms/resource-custom-roles-mysql-database-migration-service

Integrations & Coding Patterns

Topic	URL
Automate MySQL to Azure MySQL migration with DMS PowerShell	https://learn.microsoft.com/en-us/azure/dms/migrate-mysql-to-azure-mysql-powershell

Deployment

Topic	URL
Redeploy SSIS packages to Azure SQL Database with DMS	https://learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages
Migrate SSIS packages to Azure SQL Managed Instance with DMS	https://learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages-managed-instance