Sap Se

Sap Ag

Klaus Daschakowsky

Andrey Engelko

Wieland Hoprich

Dirk Debertin

Tobias Wenner

Christiane Valentin

Joerg Schoen

Florian Thomas

Wolfgang Gutberlet

Guenter Weber

Jochen Merkel

Günter Weber

A system and method for database migration is provided. In an example embodiment, the database migration technique may include a first connection to a relational database, a second connection to an in-memory database, and a migration framework to analyze the data structures of the relational database so as to identify first and second subsets of data structures. The first subset of data structures is migrated to the in-memory database during an uptime period of the relational database, and the second subset of data structures is migrated to the in-memory database during a downtime period of the relational database.

Systems and methods for in-place migration with downtime minimization

In one general aspect, a computer system can include instructions stored on a non-transitory computer-readable storage medium. The computer system can include a logging table generator configured to generate a logging table corresponding with an original table targeted for an upgrade, and a control table generator configured to generate a control table configured to store a version identifier for changes logged in the logging table. The computer system can include a change recorder configured to receive an indicator of a change to a record of the original table during execution of at least a portion of the upgrade of the original table, and a key recorder configured to store in the logging table a primary key identifying the record of the original table and the version identifier stored in the control table.

Change data capturing during an upgrade

Methods and apparatus, including computer program products, are provided for data replication. In one aspect, there is provided a computer-implemented method. The method may include providing an initial load of a data item from a source system to a target system, wherein the data item is associated with a trigger maintained at the source system; recording a change in a log, when a change to the data item at the source system causes the trigger to prompt the recording; extracting the change from the log to enable at least a confirmation of a consistency of the change; and providing the extracted change to a replication server configured to write the change to the target system. Related apparatus, systems, methods, and articles are also described.

Landscape transformation replication server

Growing community of inventors

Bad Schoenborn, Germany

Klaus Daschakowsky