Talk:Schema migration

Followup: List of schema migration tooling

A good follow up to this would be a list of tools, along with the respective programming language/ database systems that they target.

the opening definition.

The opening definition is as follows:

In software engineering, a schema migration (also database migration, database change management) refers to the management of version-controlled, incremental and sometimes reversible changes to relational database schemas.

Perhaps the word 'management' was not the best choice, and does not properly reflect the meaning of the English word 'migration', and is too general of a word to describe accurately what's going on.

Just like how birds migrate from one place to another, your database schema changes from one state to another, through time. Therefore, I propose that the definition should be something more like 'A schema migration is the change of a database's schema from one state to another '. Also, people who are already familiar with 'data migration', which simply means data changing locations, might currently get confused when the difference isn't laid bare, which I think my proposed solution would do.

My only concern is that this could be original research on my part. Since you know, places like this are where I go to try and learn this stuff to begin with... Derwos (talk) 21:01, 22 February 2024 (UTC)