{"id":"4a3b4c61-1978-442b-974d-27b2ad2c5ab0","shortId":"bsD2P4","kind":"skill","title":"azure-database-migration","tagline":"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, SQL Server/SSIS, SQL MI, or Mongo","description":"# Azure Database Migration service Skill\n\nThis 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.\n\n## How to Use This Skill\n\n> **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\n\n> **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)\n\nThis skill requires **network access** to fetch documentation content:\n- **Preferred**: Use `mcp_microsoftdocs:microsoft_docs_fetch` with query string `from=learn-agent-skill`. Returns Markdown.\n- **Fallback**: Use `fetch_webpage` with query string `from=learn-agent-skill&accept=text/markdown`. Returns Markdown.\n\n## Category Index\n\n| Category | Lines | Description |\n|----------|-------|-------------|\n| Troubleshooting | L34-L39 | Diagnosing and resolving Azure DMS classic migration failures and source DB connectivity issues (network, auth, firewall, TLS) during database migrations. |\n| Decision Making | L40-L46 | 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. |\n| Limits & Quotas | L47-L55 | Migration-specific limits, unsupported features, and constraints when using Azure DMS to move MySQL, PostgreSQL, SQL Managed Instance, MongoDB, and hybrid deployments. |\n| 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. |\n| 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. |\n| 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. |\n\n### Troubleshooting\n| Topic | URL |\n|-------|-----|\n| Troubleshoot common Azure DMS classic migration issues | https://learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms |\n| Fix Azure DMS source database connectivity problems | https://learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms-source-connectivity |\n\n### Decision Making\n| Topic | URL |\n|-------|-----|\n| Choose database migration tools with the Azure DMS matrix | https://learn.microsoft.com/en-us/azure/dms/dms-tools-matrix |\n| Answer common Azure Database Migration Service usage questions | https://learn.microsoft.com/en-us/azure/dms/faq |\n| Select supported Azure DMS migration scenarios | https://learn.microsoft.com/en-us/azure/dms/resource-scenario-status |\n\n### Limits & Quotas\n| Topic | URL |\n|-------|-----|\n| Review migration limitations to Azure Database for MySQL | https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-mysql-fs-online |\n| Review online PostgreSQL to Azure Database for PostgreSQL migration limitations | https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-postgresql-online |\n| 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 |\n| Understand Azure DMS hybrid mode limitations and issues | https://learn.microsoft.com/en-us/azure/dms/known-issues-dms-hybrid-mode |\n| Review MongoDB to Azure Cosmos DB migration limitations with DMS | https://learn.microsoft.com/en-us/azure/dms/known-issues-mongo-cosmos-db |\n\n### Security\n| Topic | URL |\n|-------|-----|\n| Apply security best practices for DMS SQL migrations | https://learn.microsoft.com/en-us/azure/dms/dms-security-best-practices |\n| Configure custom RBAC roles for MySQL migrations in DMS | https://learn.microsoft.com/en-us/azure/dms/resource-custom-roles-mysql-database-migration-service |\n\n### Integrations & Coding Patterns\n| Topic | URL |\n|-------|-----|\n| Automate MySQL to Azure MySQL migration with DMS PowerShell | https://learn.microsoft.com/en-us/azure/dms/migrate-mysql-to-azure-mysql-powershell |\n\n### Deployment\n| Topic | URL |\n|-------|-----|\n| Redeploy SSIS packages to Azure SQL Database with DMS | https://learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages |\n| 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 |","tags":["azure","database","migration","agent","skills","microsoftdocs","agent-skills","agentic-skills","agentskill","ai-agents","ai-coding","azure-functions"],"capabilities":["skill","source-microsoftdocs","skill-azure-database-migration","topic-agent","topic-agent-skills","topic-agentic-skills","topic-agentskill","topic-ai-agents","topic-ai-coding","topic-azure","topic-azure-functions","topic-azure-kubernetes-service","topic-azure-openai","topic-azure-sql-database","topic-azure-storage"],"categories":["Agent-Skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/MicrosoftDocs/Agent-Skills/azure-database-migration","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add MicrosoftDocs/Agent-Skills","source_repo":"https://github.com/MicrosoftDocs/Agent-Skills","install_from":"skills.sh"}},"qualityScore":"0.698","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 497 github stars · SKILL.md body (4,998 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-22T06:53:30.977Z","embedding":null,"createdAt":"2026-04-18T21:58:46.122Z","updatedAt":"2026-04-22T06:53:30.977Z","lastSeenAt":"2026-04-22T06:53:30.977Z","tsv":"'/en-us/azure/dms/dms-security-best-practices':517 '/en-us/azure/dms/dms-tools-matrix':419 '/en-us/azure/dms/faq':430 '/en-us/azure/dms/how-to-migrate-ssis-packages':561 '/en-us/azure/dms/how-to-migrate-ssis-packages-managed-instance':574 '/en-us/azure/dms/known-issues-azure-mysql-fs-online':454 '/en-us/azure/dms/known-issues-azure-postgresql-online':467 '/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online':479 '/en-us/azure/dms/known-issues-dms-hybrid-mode':490 '/en-us/azure/dms/known-issues-mongo-cosmos-db':503 '/en-us/azure/dms/known-issues-troubleshooting-dms':393 '/en-us/azure/dms/known-issues-troubleshooting-dms-source-connectivity':403 '/en-us/azure/dms/migrate-mysql-to-azure-mysql-powershell':546 '/en-us/azure/dms/resource-custom-roles-mysql-database-migration-service':529 '/en-us/azure/dms/resource-scenario-status':439 '/microsoftdocs/mcp/blob/main/readme.md)':166 '3':137 'accept':205 'access':171 'agent':86,130,189,203 'answer':420 'appli':507 'auth':232,312 'autom':329,535 'avail':156 'azur':2,8,28,40,51,221,246,265,284,304,333,339,359,368,386,395,414,422,433,448,459,473,481,494,538,554,566 'azure-database-migr':1 'best':309,509 'capabl':78 'categori':89,97,113,209,211 'choos':243,408 'classic':223,388 'code':21,63,324,531 'combin':68 'common':385,421 'configur':315,376,518 'connect':229,399 'consider':380 'constraint':281 'content':73,175 'cosmos':495 'cover':55 'custom':316,519 'databas':3,9,41,52,236,254,266,334,340,370,398,409,423,449,460,556 'db':228,496 'decis':15,57,238,404 'deploy':24,66,296,354,547 'descript':213 'develop':12 'diagnos':218 'dms':29,222,247,285,305,360,387,396,415,434,482,500,512,526,542,558,571 'doc':181 'document':76,174 'e.g':101,117 'encrypt':313 'end':349,351 'end-to-end':348 'exampl':353 'expert':5,48 'failur':225 'fallback':193 'faq':256 'featur':279 'fetch':77,173,182,195 'file':107,115,122,127 'firewal':233 'fix':394 'github.com':165 'github.com/microsoftdocs/mcp/blob/main/readme.md)':164 'guid':163 'guidanc':49,302 'hybrid':295,483 'import':84,128 'includ':13,307,375 'index':90,210 'instal':160,162 'instanc':292,374,476,569 'integr':20,62,323,530 'issu':230,390,487 'knowledg':6 'l120':104 'l34':216 'l34-l39':215 'l35':103 'l35-l120':102 'l39':217 'l40':241 'l40-l46':240 'l46':242 'l47':272 'l47-l55':271 'l55':273 'l56':299 'l56-l61':298 'l61':300 'l62':327 'l62-l66':326 'l66':328 'l67':356 'l67-l71':355 'l71':357 'latest':145 'learn':188,202 'learn-agent-skil':187,201 'learn.microsoft.com':392,402,418,429,438,453,466,478,489,502,516,528,545,560,573 'learn.microsoft.com/en-us/azure/dms/dms-security-best-practices':515 'learn.microsoft.com/en-us/azure/dms/dms-tools-matrix':417 'learn.microsoft.com/en-us/azure/dms/faq':428 'learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages':559 'learn.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages-managed-instance':572 'learn.microsoft.com/en-us/azure/dms/known-issues-azure-mysql-fs-online':452 'learn.microsoft.com/en-us/azure/dms/known-issues-azure-postgresql-online':465 'learn.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online':477 'learn.microsoft.com/en-us/azure/dms/known-issues-dms-hybrid-mode':488 'learn.microsoft.com/en-us/azure/dms/known-issues-mongo-cosmos-db':501 'learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms':391 'learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms-source-connectivity':401 'learn.microsoft.com/en-us/azure/dms/migrate-mysql-to-azure-mysql-powershell':544 'learn.microsoft.com/en-us/azure/dms/resource-custom-roles-mysql-database-migration-service':527 'learn.microsoft.com/en-us/azure/dms/resource-scenario-status':437 'limit':17,59,260,269,277,440,446,464,471,485,498 'line':99,111,212 'link':116,125 'local':69 'locat':93 'make':16,58,239,405 'manag':291,373,475,568 'markdown':192,208 'matrix':416 'mcp':151,178 'metadata.generated':132 'mi':37 'microsoft':180 'microsoftdoc':152,179 'migrat':4,10,30,42,53,224,237,259,267,275,306,321,337,341,364,379,389,410,424,435,445,463,470,497,514,524,540,562 'migration-specif':274 'mode':484 'mongo':39 'mongodb':293,492 'month':138 'move':287 'mysql':32,288,320,331,336,451,523,536,539 'mysql-to-azur':330 'network':170,231,311 'old':139 'onlin':456,469 'packag':366,552,564 'paramet':346 'pattern':22,64,325,532 'plan':27 'plus':255 'postgresql':33,289,457,462 'powershel':344,543 'practic':310,510 'prefer':176 'problem':400 'provid':47 'pull':143 'queri':184,198 'question':427 'quick':71 'quick-refer':70 'quota':18,60,270,441 'rang':100 'rbac':317,520 'read':106,121 'redeploy':362,550 'refer':72,126 'relev':94 'remot':75 'repositori':149 'requir':169 'resolv':220 'return':191,207 'review':444,455,468,491 'right':245 'role':318,521 'scenario':250,322,436 'script':345 'section':95 'secur':19,61,297,301,504,508 'security.md':118,119 'select':431 'server/ssis':35 'servic':11,43,54,268,342,425 'skill':44,46,83,168,190,204 'skill-azure-database-migration' 'sourc':227,397 'source-microsoftdocs' 'source/target':253 'specif':276 'specifi':110 'sql':34,36,290,308,369,372,474,513,555,567 'ssis':365,551,563 'step':377 'string':185,199 'suggest':140,157 'support':258,432 'text/markdown':206 'tls':234 'tool':153,248,411 'topic':382,406,442,505,533,548 'topic-agent' 'topic-agent-skills' 'topic-agentic-skills' 'topic-agentskill' 'topic-ai-agents' 'topic-ai-coding' 'topic-azure' 'topic-azure-functions' 'topic-azure-kubernetes-service' 'topic-azure-openai' 'topic-azure-sql-database' 'topic-azure-storage' 'troubleshoot':14,56,214,381,384 'understand':480 'unsupport':278 'url':383,407,443,506,534,549 'usag':426 'use':25,81,87,105,120,177,194,264,283,338,358 'user':142,159 'version':146 'webpag':196 'workflow':352","prices":[{"id":"47465e18-448a-400b-97ef-169888b57f3e","listingId":"4a3b4c61-1978-442b-974d-27b2ad2c5ab0","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"MicrosoftDocs","category":"Agent-Skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:58:46.122Z"}],"sources":[{"listingId":"4a3b4c61-1978-442b-974d-27b2ad2c5ab0","source":"github","sourceId":"MicrosoftDocs/Agent-Skills/azure-database-migration","sourceUrl":"https://github.com/MicrosoftDocs/Agent-Skills/tree/main/skills/azure-database-migration","isPrimary":false,"firstSeenAt":"2026-04-18T21:58:46.122Z","lastSeenAt":"2026-04-22T06:53:30.977Z"}],"details":{"listingId":"4a3b4c61-1978-442b-974d-27b2ad2c5ab0","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"MicrosoftDocs","slug":"azure-database-migration","github":{"repo":"MicrosoftDocs/Agent-Skills","stars":497,"topics":["agent","agent-skills","agentic-skills","agentskill","ai","ai-agents","ai-coding","azure","azure-functions","azure-kubernetes-service","azure-openai","azure-sql-database","azure-storage","azure-virtual-machine","claude-code","github-copilot","microsoft-learn","openai-codex","skills"],"license":"cc-by-4.0","html_url":"https://github.com/MicrosoftDocs/Agent-Skills","pushed_at":"2026-04-22T01:37:27Z","description":"Curated Agent Skills for Microsoft & Azure – giving AI coding assistants structured, real-time expertise from Microsoft Learn docs.","skill_md_sha":"240d34a43e0d5cbbea8d4c94136b2d742b6b8811","skill_md_path":"skills/azure-database-migration/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/MicrosoftDocs/Agent-Skills/tree/main/skills/azure-database-migration"},"layout":"multi","source":"github","category":"Agent-Skills","frontmatter":{"name":"azure-database-migration","description":"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, SQL Server/SSIS, SQL MI, or MongoDB 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).","compatibility":"Requires network access. Uses mcp_microsoftdocs:microsoft_docs_fetch or fetch_webpage to retrieve documentation."},"skills_sh_url":"https://skills.sh/MicrosoftDocs/Agent-Skills/azure-database-migration"},"updatedAt":"2026-04-22T06:53:30.977Z"}}