{"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 migrating SQL/MySQL/PostgreSQL/MongoDB with Azure DMS, SSIS to Azure SQL/MI, or automa","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-L40 | Diagnosing and fixing Azure DMS issues: migration failures, classic DMS problems, and source database connectivity errors, including common causes, logs, and remediation steps. |\n| Decision Making | L41-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| Resolve common Azure Database Migration Service issues | https://learn.microsoft.com/en-us/azure/dms/faq |\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| 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.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 549 github stars · SKILL.md body (5,012 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-05-18T18:53:51.828Z","embedding":null,"createdAt":"2026-04-18T21:58:46.122Z","updatedAt":"2026-05-18T18:53:51.828Z","lastSeenAt":"2026-05-18T18:53:51.828Z","tsv":"'/en-us/azure/dms/dms-security-best-practices':517 '/en-us/azure/dms/dms-tools-matrix':430 '/en-us/azure/dms/faq':394 '/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':404 '/en-us/azure/dms/known-issues-troubleshooting-dms-source-connectivity':414 '/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)':164 '3':135 'accept':203 'access':169 'agent':84,128,187,201 'appli':507 'auth':313 'autom':330,535 'automa':37 'avail':154 'azur':2,8,30,34,38,49,219,247,266,285,305,334,340,360,369,387,397,406,425,433,448,459,473,481,494,538,554,566 'azure-database-migr':1 'best':310,509 'capabl':76 'categori':87,95,111,207,209 'caus':234 'choos':244,419 'classic':224,399 'code':21,61,325,531 'combin':66 'common':233,386,396 'configur':316,377,518 'connect':230,410 'consider':381 'constraint':282 'content':71,173 'cosmos':495 'cover':53 'custom':317,519 'databas':3,9,39,50,229,255,267,335,341,371,388,409,420,449,460,556 'db':496 'decis':15,55,239,415 'deploy':24,64,297,355,547 'descript':211 'develop':12 'diagnos':216 'dms':31,220,225,248,286,306,361,398,407,426,434,482,500,512,526,542,558,571 'doc':179 'document':74,172 'e.g':99,115 'encrypt':314 'end':350,352 'end-to-end':349 'error':231 'exampl':354 'expert':5,46 'failur':223 'fallback':191 'faq':257 'featur':280 'fetch':75,171,180,193 'file':105,113,120,125 'fix':218,405 'github.com':163 'github.com/microsoftdocs/mcp/blob/main/readme.md)':162 'guid':161 'guidanc':47,303 'hybrid':296,483 'import':82,126 'includ':13,232,308,376 'index':88,208 'instal':158,160 'instanc':293,375,476,569 'integr':20,60,324,530 'issu':221,391,401,487 'knowledg':6 'l120':102 'l34':214 'l34-l40':213 'l35':101 'l35-l120':100 'l40':215 'l41':242 'l41-l46':241 'l46':243 'l47':273 'l47-l55':272 'l55':274 'l56':300 'l56-l61':299 'l61':301 'l62':328 'l62-l66':327 'l66':329 'l67':357 'l67-l71':356 'l71':358 'latest':143 'learn':186,200 'learn-agent-skil':185,199 'learn.microsoft.com':393,403,413,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':428 'learn.microsoft.com/en-us/azure/dms/faq':392 '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':402 'learn.microsoft.com/en-us/azure/dms/known-issues-troubleshooting-dms-source-connectivity':412 '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,57,261,270,278,440,446,464,471,485,498 'line':97,109,210 'link':114,123 'local':67 'locat':91 'log':235 'make':16,56,240,416 'manag':292,374,475,568 'markdown':190,206 'matrix':427 'mcp':149,176 'metadata.generated':130 'microsoft':178 'microsoftdoc':150,177 'migrat':4,10,27,40,51,222,260,268,276,307,322,338,342,365,380,389,400,421,435,445,463,470,497,514,524,540,562 'migration-specif':275 'mode':484 'mongodb':294,492 'month':136 'move':288 'mysql':289,321,332,337,451,523,536,539 'mysql-to-azur':331 'network':168,312 'old':137 'onlin':456,469 'packag':367,552,564 'paramet':347 'pattern':22,62,326,532 'plus':256 'postgresql':290,457,462 'powershel':345,543 'practic':311,510 'prefer':174 'problem':226,411 'provid':45 'pull':141 'queri':182,196 'quick':69 'quick-refer':68 'quota':18,58,271,441 'rang':98 'rbac':318,520 'read':104,119 'redeploy':363,550 'refer':70,124 'relev':92 'remedi':237 'remot':73 'repositori':147 'requir':167 'resolv':385 'return':189,205 'review':444,455,468,491 'right':246 'role':319,521 'scenario':251,323,436 'script':346 'section':93 'secur':19,59,298,302,504,508 'security.md':116,117 'select':431 'servic':11,41,52,269,343,390 'skill':42,44,81,166,188,202 'skill-azure-database-migration' 'sourc':228,408 'source-microsoftdocs' 'source/target':254 'specif':277 'specifi':108 'sql':291,309,370,373,474,513,555,567 'sql/mi':35 'sql/mysql/postgresql/mongodb':28 'ssis':32,366,551,563 'step':238,378 'string':183,197 'suggest':138,155 'support':259,432 'text/markdown':204 'tool':151,249,422 'topic':383,417,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,54,212,382,395 'understand':480 'unsupport':279 'url':384,418,443,506,534,549 'use':25,79,85,103,118,175,192,265,284,339,359 'user':140,157 'version':144 'webpag':194 'workflow':353","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-05-18T18:53:51.828Z"}],"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":549,"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-05-17T02:50:05Z","description":"Curated Agent Skills for Microsoft & Azure – giving AI coding assistants structured, real-time expertise from Microsoft Learn docs.","skill_md_sha":"bb7e4197ef7aa524994f8c8ab3b5928eba15d363","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 migrating SQL/MySQL/PostgreSQL/MongoDB with Azure DMS, SSIS to Azure SQL/MI, or automating via PowerShell, 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-05-18T18:53:51.828Z"}}