II.
LibraryProcess overview
Reference · livelib-process:code-migration-modernization--database-schema-migration
specializations/code-migration-modernization/database-schema-migration overview
Database Schema Migration - Comprehensive process for migrating database schemas between versions or platforms while ensuring data integrity, minimal downtime using expand-contract pattern, and reversibility with proper validation.
Attributes
displayName
specializations/code-migration-modernization/database-schema-migration
description
Database Schema Migration - Comprehensive process for migrating database schemas between
versions or platforms while ensuring data integrity, minimal downtime using expand-contract pattern,
and 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', {
projectName: 'Order Service DB Migration',
sourceDatabase: { type: 'Oracle', version: '12c', schema: 'orders' },
targetDatabase: { type: 'PostgreSQL', version: '15', schema: 'orders_v2' },
migrationTool: 'flyway',
downtimeConstraint: 'zero-downtime'
});
usesAgents
- database-migration-orchestrator
- data-integrity-validator
- cutover-coordinator
Outgoing edges
lib_applies_to_domain1
- domain:software-engineering·DomainSoftware Engineering
lib_belongs_to_specialization1
- specialization:code-migration-modernization·Specialization
lib_covers_topic1
- topic:refactoring·TopicRefactoring
lib_implements_workflow1
- workflow:technical-debt-reduction·WorkflowTechnical Debt Reduction
lib_involves_role2
- role:architect·RoleArchitect
- role:tech-lead·RoleTech Lead
lib_requires_skill_area3
- skill-area:strangler-fig-pattern·SkillAreaStrangler Fig Migration
- skill-area:parallel-run-migration·SkillAreaParallel-Run Migration
- skill-area:database-migrations-zero-downtime·SkillAreaZero-Downtime Database Migrations
uses_agent3
- lib-agent:code-migration-modernization--database-migration-orchestrator·LibraryAgentdatabase-migration-orchestrator
- lib-agent:code-migration-modernization--data-integrity-validator·LibraryAgentdata-integrity-validator
- lib-agent:code-migration-modernization--cutover-coordinator·LibraryAgentcutover-coordinator
Incoming edges
None.