Handling Table Deltas During Zero Downtime Upgrade

摘要

A zero downtime upgrade of a source system to a target system is initiated. The source system and the target system operate in a first database layer and a second database layer. Thereafter, differences in structure and/or database type are computed between a source table in the source system and a target table in the target system in each of the two different database layers. The data is then migrated, using the computing differences and in the second database layer, from the source table to the target table. The upgrade procedure is later terminated after completion of the migration of the data. Related apparatus, systems, techniques and articles are also described.

主权项

1. A method comprising:
initiating a zero downtime upgrade of a source system to a target system, the upgrade procedure preparing software for the target system in parallel to operation of the source system by selectively (i) cloning, for the target system, tables and associated database triggers used by the source system according to a source database schema, (ii) generating new target tables comprising updated software content for use by a bridge database schema, and (iii) selectively sharing tables between the source database schema and the bridge database schema, the source system and the target system operating in a first database layer and a second database layer; computing differences in structure and/or database type between a source table in the source system and a target table in the target system in each of the two different database layers; migrating, using the computing differences and in the second database layer, data from the source table to the target table; and terminating the upgrade procedure after completion of the migration of the data.