SAP SE
Deployment of automated migrations for database tables

Abstract:

In an example embodiment, a new development infrastructure is provided that provides an external repository for database definitions. The development infrastructure also then includes a development mode. When using the development mode, the behavior of the development infrastructure is modified to better fit the development of database artifacts. The developer uses a development base version of a definition (usually the latest released version of the definition) but also creates migrations that indicate how the development base version should be modified to arrive at the developer's intended new definition. While still in development mode, the deployment may be run, which causes data in the development mode that uses the old definition to be dropped and replaced by the base version. The development mode then executes the specified migrations.