Technology Evaluation - CouchDB Schema Migration

From wiki.gpii
Jump to: navigation, search

Introduction

Requirements

Candidates

Notes

Schema Migrations 'Key Points' from "NoSQL Distilled":

  • Databases with strong schemas, such as relational databases, can be migrated by saving each schema change, plus its data migration, in a version-controlled sequence.
  • Schemaless databases still need careful migration due to the implicit schema in any code that accesses the data.
  • Schemaless databases can use the same migration techniques as databases with strong schemas.
  • Schemaless databases can also read data in a way that's tolerant to changes in the data's implicit schema and use incremental migration to update data.

https://martinfowler.com/articles/nosqlKeyPoints.html

SQL Tools