{"kind":"Skill","metadata":{"namespace":"community","name":"creating-oracle-to-postgres-master-migration-plan","version":"0.1.0"},"spec":{"description":"Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or assessing which .NET projects contain Oracle dependencies.","files":{"SKILL.md":"---\nname: creating-oracle-to-postgres-master-migration-plan\ndescription: 'Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or assessing which .NET projects contain Oracle dependencies.'\n---\n\n# Creating an Oracle-to-PostgreSQL Master Migration Plan\n\nAnalyze a .NET solution, classify every project for Oracle→PostgreSQL migration eligibility, and write a structured plan that downstream agents and skills can parse.\n\n## Workflow\n\n```\nProgress:\n- [ ] Step 1: Discover projects in the solution\n- [ ] Step 2: Classify each project\n- [ ] Step 3: Confirm with user\n- [ ] Step 4: Write the plan file\n```\n\n**Step 1: Discover projects**\n\nFind the Solution File (it has a `.sln` or `.slnx` extension) in the workspace root (ask the user if multiple exist). Parse it to extract all `.csproj` project references. For each project, note the name, path, and type (class library, web API, console, test, etc.).\n\n**Step 2: Classify each project**\n\nScan every non-test project for Oracle indicators:\n\n- NuGet references: `Oracle.ManagedDataAccess`, `Oracle.EntityFrameworkCore` (check `.csproj` and `packages.config`)\n- Config entries: Oracle connection strings in `appsettings.json`, `web.config`, `app.config`\n- Code usage: `OracleConnection`, `OracleCommand`, `OracleDataReader`\n- DDL cross-references under `.github/oracle-to-postgres-migration/DDL/Oracle/` (if present)\n\nAssign one classification per project:\n\n| Classification | Meaning |\n|---|---|\n| **MIGRATE** | Has Oracle interactions requiring conversion |\n| **SKIP** | No Oracle indicators (UI-only, shared utility, etc.) |\n| **ALREADY_MIGRATED** | A `-postgres` or `.Postgres` duplicate exists and appears processed |\n| **TEST_PROJECT** | Test project; handled by the testing workflow |\n\n**Step 3: Confirm with user**\n\nPresent the classified list. Let the user adjust classifications or migration ordering before finalizing.\n\n**Step 4: Write the plan file**\n\nSave to: `.github/oracle-to-postgres-migration/Reports/Master Migration Plan.md`\n\nUse this exact template — downstream consumers depend on the structure:\n\n````markdown\n# Master Migration Plan\n\n**Solution:** {solution file name}\n**Solution Root:** {REPOSITORY_ROOT}\n**Created:** {timestamp}\n**Last Updated:** {timestamp}\n\n## Solution Summary\n\n| Metric | Count |\n|--------|-------|\n| Total projects in solution | {n} |\n| Projects requiring migration | {n} |\n| Projects already migrated | {n} |\n| Projects skipped (no Oracle usage) | {n} |\n| Test projects (handled separately) | {n} |\n\n## Project Inventory\n\n| # | Project Name | Path | Classification | Notes |\n|---|---|---|---|---|\n| 1 | {name} | {relative path} | MIGRATE | {notes} |\n| 2 | {name} | {relative path} | SKIP | No Oracle dependencies |\n\n## Migration Order\n\n1. **{ProjectName}** — {rationale, e.g., \"Core data access library; other projects depend on it.\"}\n2. **{ProjectName}** — {rationale}\n````\n\nOrder projects so that shared/foundational libraries are migrated before their dependents.\n"},"import":{"commit_sha":"541b7819d8c3545c6df122491af4fa1eae415779","imported_at":"2026-05-18T20:05:35Z","license_text":"MIT License\n\nCopyright GitHub, Inc.\n\nPermission is hereby granted, free of charge, to any person obtaining a copy\nof this software and associated documentation files (the \"Software\"), to deal\nin the Software without restriction, including without limitation the rights\nto use, copy, modify, merge, publish, distribute, sublicense, and/or sell\ncopies of the Software, and to permit persons to whom the Software is\nfurnished to do so, subject to the following conditions:\n\nThe above copyright notice and this permission notice shall be included in all\ncopies or substantial portions of the Software.\n\nTHE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR\nIMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,\nFITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE\nAUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER\nLIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,\nOUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE\nSOFTWARE.","owner":"github","repo":"github/awesome-copilot","source_url":"https://github.com/github/awesome-copilot/tree/541b7819d8c3545c6df122491af4fa1eae415779/plugins/oracle-to-postgres-migration-expert/skills/creating-oracle-to-postgres-master-migration-plan"}},"content_hash":[62,238,239,166,208,101,110,172,200,114,87,122,159,225,98,126,223,5,7,198,105,215,219,209,207,218,64,158,72,178,178,50],"trust_level":"unsigned","yanked":false}