Schema Migrations

Schema Migrations

1. Schema changes

   • NoSQL
     • Schemaless
       • Promotion
         • Agile Methods
     • Data schema
       • Definition
         • Application
           • Parsing
           • Changes
   • RDBMS
     • Modifying the object model
       • Object
       • Database table
       • Techniques
         • Script names notation
           • Incremental numbers
         • DBDeploy
           • Change Log
             • Table
             • Storage of changes
       • Recommendations
         • During development stage
           • Green Field Projects
         • Project's version control repository
           • Tools
             • Liquibase
             • DBMaintain
       • Data migration

2. Migrations in Legacy Projects

   • Production Stage
   • Baseline
     • Database structure scripts
   • Techniques
     • Use of transition phase
       • Backward compatibility
       • Working on
         • Old schema
         • New schema
       • Applying structures
         • Virtual columns
         • Views
         • Triggers