Sap Se

Sap Ag

Heiko Konrad

Volker Driesen

Juergen Specht

Steffen Meissner

Lars-Eric Biewald

Wieland Hoprich

Martin Hartig

Martin Mayer

Christoph Luettge

Matthias Mittelstein

Edgar Willi Lott

Andrey Engelko

Kerstin Hoeft

Ulrich Auer

Ralf-Juergen Hauck

Andrea Neufeld

Levke Bentzien

Tamara Weckwerth

Joerg Schoen

Andre Haferkorn

Florian Thomas

Christian Lutter

Erwin Burkhardt

A system and method for database migration is provided. In an example embodiment, the database migration technique may include execution modules having a first connection to a source database and a second connection to a target database, and orchestration modules adapted to identify first and second subsets of statements from a single storage table, wherein the first and second subsets of statements are executed by the execution modules during an uptime period of the source database.

Asynchronous SQL execution tool for zero downtime and migration to HANA

The present disclosure teaches solutions for patching content in database systems. In one example, a deployment package for an upgrade of a database system to a new system is received, and the content is deployed to a shared container. Shared objects are identified that are completely stored in the shared container, and partially-shared objects are identified where those objects have a shared portion in the shared container and a tenant portion in one or more tenant containers. First shared content is determined for the shared objects, while second shared content is determined for partially-shared objects. The first and second shared content is then deployed to the shared container. Local content is determined for the partially-shared objects and is deployed to each tenant container. Local content is then identified for local objects and is also deployed to each respective tenant container. Accordingly, both shared and tenant content is deployed.

Patching content across shared and tenant containers in multi-tenancy database systems

A zero downtime upgrade procedure is initiated that upgrades a first version of software executing on a source system comprising at least one source server to a second version of software executing on a target system comprising at least one target server. The source system initially starts operating in a read-write mode. Thereafter, concurrent with the operation of the source system, operation of the target system is initiated in a read-only mode. Operations of the source system are then ceased by ramping down activities of the source system. Upon cessation of operation of the source system, operation of the target system is initiated in a read-write mode.

Zero downtime software system upgrade

The disclosure generally describes methods, software, and systems, including a method for updating an application. At least one application instance of an application is managed. Each application instance is associated with a plurality of executing work processes connected with a first database schema. A bridge database schema is generated that is related to the first database schema. The bridge database schema represents a copy of the first database schema and is generated in response to initiation of an update to the application. In response to determining that the generation of the bridge database schema is complete, for each of the plurality of work processes, a commit work action performed by the particular work process is determined. In response to determining performance of the commit work action, the particular work process is connected to the bridge database schema.

Dynamic reconnect of work processes in a zero downtime maintenance procedure

The present disclosure describes methods, systems, and computer program products for providing multi-level user interface theming. One computer-implemented method includes instantiating a shadow system and database schema for a new version software application in a shared database, the shadow system database schema containing aliases pointing to tables instantiated in a production database schema, instantiating a bridge database schema containing aliases pointing to each database table within the production database schema, preparing a bridge sub-system connected to the bridge database schema aliases, replicating database tables within the production database schema, for use by the bridge sub-system and adjusting the original database tables for structure and content consistent with the new version software application, deploying an upgrade sub-system and tools to complete adjustment of structure and content of the original database tables, and connecting an instantiated instance of the new version software application to adjusted database tables.

Zero downtime maintenance with maximum business functionality

A zero downtime upgrade procedure upgrading a source system to a target system is initiated that prepares software for the target system in parallel to the operation of the source system. As part of the upgrade procedure, source tables of the source system are renamed. Thereafter, the renamed source tables are cloned for the target system. Further, the renamed source tables are equipped with database triggers to transfer data from the renamed source tables to the cloned tables used by the source system according to a source database schema. Next, the target tables are generated that include updated software content for later use by the target system while the source tables are used via a bridge database schema. Tables can then be shared between the source database schema accessed via the bridge database schema and the target system.

Data access management during zero downtime upgrade

Revocation of a zero downtime upgrade of an upgrade procedure of a source system to a target system is initiated. Thereafter, upgrade activities are stopped at the target system and production activities are stopped at the source system. At least a portion of the target tables can be subsequently dropped and any associated table structure changes can be revoked. At least a portion of the target tables are then switched from use by the target system to use by the source system. Next, the source system is connected to the source database schema to enable use of the source system in its state prior to the initiation of the upgrade procedure. Related apparatus, systems, techniques and articles are also described.

Revoking a zero downtime upgrade

A computer-implemented method for modifying software code includes: processing a command to modify a first module of software code stored on a production system in a distributed computing environment, where the software code includes a first plurality of data objects and a first plurality of notes; generating at least one queue comprising the second plurality of notes; modifying a second module of software code stored on a development system in the distributed computing environment with the second plurality of notes, where the second module of software code comprising a version of the first module of software code; and transferring the second module of software code to the production system to modify the first module of software code such that the first plurality of notes are modified by the second plurality of notes.

Modifying software code

Growing community of inventors

Hockenheim, Germany

Heiko Konrad