{
  "id": "lib-process:code-migration-modernization--database-schema-migration",
  "_kind": "LibraryProcess",
  "_file": "generated-library/processes.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "specializations/code-migration-modernization/database-schema-migration",
    "description": "Database Schema Migration - Comprehensive process for migrating database schemas between\nversions or platforms while ensuring data integrity, minimal downtime using expand-contract pattern,\nand reversibility with proper validation.",
    "libraryPath": "library/specializations/code-migration-modernization/database-schema-migration.js",
    "specialization": "code-migration-modernization",
    "references": [
      "- Flyway: https://flywaydb.org/",
      "- Liquibase: https://www.liquibase.org/",
      "- Database Refactoring: https://martinfowler.com/books/refactoringDatabases.html",
      "- Expand and Contract Pattern: https://martinfowler.com/bliki/ParallelChange.html"
    ],
    "example": "const result = await orchestrate('specializations/code-migration-modernization/database-schema-migration', {\n  projectName: 'Order Service DB Migration',\n  sourceDatabase: { type: 'Oracle', version: '12c', schema: 'orders' },\n  targetDatabase: { type: 'PostgreSQL', version: '15', schema: 'orders_v2' },\n  migrationTool: 'flyway',\n  downtimeConstraint: 'zero-downtime'\n});",
    "usesAgents": [
      "database-migration-orchestrator",
      "data-integrity-validator",
      "cutover-coordinator"
    ]
  },
  "outgoingEdges": [
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "skill-area:strangler-fig-pattern",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "skill-area:parallel-run-migration",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "topic:refactoring",
      "kind": "lib_covers_topic",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "domain:software-engineering",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "role:architect",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "role:tech-lead",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "workflow:technical-debt-reduction",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "specialization:code-migration-modernization",
      "kind": "lib_belongs_to_specialization",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "lib-agent:code-migration-modernization--database-migration-orchestrator",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "lib-agent:code-migration-modernization--data-integrity-validator",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "lib-agent:code-migration-modernization--cutover-coordinator",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    }
  ],
  "incomingEdges": []
}