1---
2name: azure-database-migration
3description: Expert knowledge for Azure Database Migration Service development including troubleshooting, decision making, limits & quotas, security, integrations & coding patterns, and deployment. Use when planning Azure DMS migrations for MySQL, PostgreSQL, MongoDB, SSIS-to-Azure SQL, or hybrid workloads, and other Azure Database Migration Service related development tasks. Not for Azure Migrate (use azure-migrate), Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines).
4compatibility: Requires network access. Uses mcp_microsoftdocs:microsoft_docs_fetch or fetch_webpage to retrieve documentation.
5metadata:
6 generated_at: "2026-08-31"
7 generator: "docs2skills/1.0.0"
8---
9
10# Azure Database Migration Service Skill
11
12This 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.
13
14## How to Use This Skill
15
16> **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
17
18> **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](https://github.com/MicrosoftDocs/mcp/blob/main/README.md)
19
20This skill requires **network access** to fetch documentation content:
21- **Preferred**: Use `mcp_microsoftdocs:microsoft_docs_fetch` with query string `from=learn-agent-skill`. Returns Markdown.
22- **Fallback**: Use `fetch_webpage` with query string `from=learn-agent-skill&accept=text/markdown`. Returns Markdown.
23
24## Category Index
25
26| Category | Lines | Description |
27|----------|-------|-------------|
28| Troubleshooting | L34-L41 | Diagnosing and fixing Azure DMS migration failures, MySQL-specific issues, classic DMS problems, and source database connectivity errors and timeouts. |
29| Decision Making | L42-L47 | Guidance on choosing Azure migration tools and understanding which database migration scenarios Azure Database Migration Service supports and how to select the right approach. |
30| 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. |
31| 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. |
32| 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. |
33| 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. |
34
35### Troubleshooting
36| Topic | URL |
37|-------|-----|
38| Resolve common Azure DMS migration issues | https://learn.microsoft.com/en-us/azure/dms/faq |
39| Resolve known issues migrating to Azure MySQL | https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-mysql-fs-online |
40| Troubleshoot common Azure DMS classic migration issues | https://learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms |
41| Fix Azure DMS source database connectivity problems | https://learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms-source-connectivity |
42
43### Decision Making
44| Topic | URL |
45|-------|-----|
46| Select tools for Azure database migration | https://learn.microsoft.com/en-us/azure/dms/dms-tools-matrix |
47| Select supported Azure DMS migration scenarios | https://learn.microsoft.com/en-us/azure/dms/resource-scenario-status |
48
49### Limits & Quotas
50| Topic | URL |
51|-------|-----|
52| Review online PostgreSQL to Azure Database for PostgreSQL migration limitations | https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-postgresql-online |
53| 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 |
54| Understand Azure DMS hybrid mode limitations and issues | https://learn.microsoft.com/en-us/azure/dms/known-issues-dms-hybrid-mode |
55| Review MongoDB to Azure Cosmos DB migration limitations with DMS | https://learn.microsoft.com/en-us/azure/dms/known-issues-mongo-cosmos-db |
56
57### Security
58| Topic | URL |
59|-------|-----|
60| Apply security best practices for DMS SQL migrations | https://learn.microsoft.com/en-us/azure/dms/dms-security-best-practices |
61| Configure custom RBAC roles for MySQL migrations in DMS | https://learn.microsoft.com/en-us/azure/dms/resource-custom-roles-mysql-database-migration-service |
62
63### Integrations & Coding Patterns
64| Topic | URL |
65|-------|-----|
66| Automate MySQL to Azure MySQL migration with DMS PowerShell | https://learn.microsoft.com/en-us/azure/dms/migrate-mysql-to-azure-mysql-powershell |
67
68### Deployment
69| Topic | URL |
70|-------|-----|
71| Redeploy SSIS packages to Azure SQL Database with DMS | https://learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages |
72| 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 |
gabrielmoreira