IP Library › Granted Patent US 11,120,080
Granted Patent B2
US 11,120,080 · App. 15/997,678 · Granted Sep 14, 2021

System and method for migrating databases

Inventor: Wieland Hoprich (Mannheim, DE)
Assignee: SAP SE
G06F16/901G06F8/65G06F16/23G06F16/907
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,120,080
App. No.
15/997,678
Granted
Sep 14, 2021
Kind
B2
Abstract

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives data from a subset of a first set of exchange tables stored in a first database of a source system. The program further creates a second set of exchange tables in a second database of the device. The program also creates a set of shadow tables in the second database of the device. The program further adapts the second set of exchange tables and the set of shadow tables to a higher upgrade version. The program also performs object generation based on the second set of exchange tables and the set of shadow tables. The program further drops the set of shadow tables. The program also receives a set of application tables from the source system. The program further adapts the set of application tables to the higher upgrade version.

Claims (58)

1. A non-transitory machine-readable medium storing a program executable by at least one processing unit of a device, the program comprising sets of instructions for:

receiving data from a subset of a first set of exchange tables stored in a first database of a source system;

creating a second set of exchange tables in a second database of the device, the second set of exchange tables comprising the data from the subset of the first set of exchange tables and data from an upgrade version of the set of exchange tables stored in the first database of the source system;

creating a set of shadow tables in the second database of the device, wherein the set of shadow tables corresponds to a subset of a first set of application tables stored in the first database of the source system, the set of shadow tables comprising data from an upgrade version of the subset of the first set of application tables stored in the first database of the source system, wherein the set of shadow tables include a minimal set of data required for operation of the first kernel on the device;

installing, on the device, a first kernel that is a higher upgrade version of a second kernel operating on the source system;

adapting the second set of exchange tables and the set of shadow tables to the higher upgrade version;

performing object generation based on the second set of exchange tables and the set of shadow tables;

dropping the set of shadow tables;

receiving a set of application tables from the source system; and

adapting the set of application tables to the higher upgrade version.

2. The non-transitory machine-readable medium of claim 1 , wherein the program further comprises set of instructions for:

receiving, from the source system, a first set of table metadata associated with the first set of exchange tables stored in the first database of the source system and the first set of application tables stored in the first database of the source system;

receiving a second set of table metadata associated with an upgrade version of the first set of exchange tables stored in the first database of the source system and an upgrade version of the first set of application tables stored in the first database of the source system;

determining a set of differences between the first set of table metadata and the second set of table metadata; and

generating a set of instructions based on the set of differences,

wherein adapting the set of application tables to the higher upgrade version comprises executing the set of instructions.

3. The non-transitory machine-readable medium of claim 2 , wherein the first set of table metadata and the second set of table metadata are received from a file directory shared between the device and the source system.

4. The non-transitory machine-readable medium of claim 1 , wherein the machine-readable medium is a first machine-readable medium, wherein the program further comprises a set of instructions for retrieving the data from the upgrade version of the set of exchange tables stored on the source system from a second machine-readable medium.

5. The non-transitory machine-readable medium of claim 4 , wherein the program further comprises a set of instructions for retrieving the data from the upgrade version of the set of shadow tables stored on the source system from the second machine-readable medium.

6. For a device, a method comprising:

receiving data from a subset of a first set of exchange tables stored in a first database of a source system;

creating a second set of exchange tables in a second database of the device, the second set of exchange tables comprising the data from the subset of the first set of exchange tables and data from an upgrade version of the set of exchange tables stored in the first database of the source system;

creating a set of shadow tables in the second database of the device, wherein the set of shadow tables corresponds to a subset of a first set of application tables stored in the first database of the source system, the set of shadow tables comprising data from an upgrade version of the subset of the first set of application tables stored in the first database of the source system, wherein the set of shadow tables include a minimal set of data required for operation of the first kernel on the device;

installing, on the device, a first kernel that is a higher upgrade version of a second kernel operating on the source system;

adapting the second set of exchange tables and the set of shadow tables to the higher upgrade version;

performing object generation based on the second set of exchange tables and the set of shadow tables;

dropping the set of shadow tables;

receiving a set of application tables from the source system; and

adapting the set of application tables to the higher upgrade version.

7. The method of claim 6 further comprising:

receiving, from the source system, a first set of table metadata associated with the first set of exchange tables stored in the first database of the source system and the first set of application tables stored in the first database of the source system;

receiving a second set of table metadata associated with an upgrade version of the first set of exchange tables stored in the first database of the source system and an upgrade version of the first set of application tables stored in the first database of the source system;

determining a set of differences between the first set of table metadata and the second set of table metadata; and

generating a set of instructions based on the set of differences,

wherein adapting the set of application tables to the higher upgrade version comprises executing the set of instructions.

8. The method of claim 7 , wherein the first set of table metadata and the second set of table metadata are received from a file directory shared between the device and the source system.

9. The method of claim 6 further comprising retrieving the data from the upgrade version of the set of exchange tables stored on the source system from a machine-readable medium.

10. The method of claim 9 further comprising retrieving the data from the upgrade version of the set of shadow tables stored on the source system from the second machine-readable medium.

11. A system comprising:

a set of processing units; and

a non-transitory machine-readable medium storing instructions that when executed by at least one processing unit in the set of processing units cause the at least one processing unit to:

receive data from a subset of a first set of exchange tables stored in a first database of a source system;

create a second set of exchange tables in a second database of the system, the second set of exchange tables comprising the data from the subset of the first set of exchange tables and data from an upgrade version of the set of exchange tables stored in the first database of the source system;

create a set of shadow tables in the second database of the system, wherein the set of shadow tables corresponds to a subset of a first set of application tables stored in the first database of the source system, the set of shadow tables comprising data from an upgrade version of the subset of the first set of application tables stored in the first database of the source system, wherein the set of shadow tables include a minimal set of data required for operation of the first kernel on the device;

install, on the system, a first kernel that is a higher upgrade version of a second kernel operating on the source system;

adapt the second set of exchange tables and the set of shadow tables to the higher upgrade version;

perform object generation based on the second set of exchange tables and the set of shadow tables;

drop the set of shadow tables;

receive a set of application tables from the source system; and

adapt the set of application tables to the higher upgrade version.

12. The system of claim 11 , wherein the instructions further cause the at least one processing unit to:

receive, from the source system, a first set of table metadata associated with the first set of exchange tables stored in the first database of the source system and the first set of application tables stored in the first database of the source system;

receive a second set of table metadata associated with an upgrade version of the first set of exchange tables stored in the first database of the source system and an upgrade version of the first set of application tables stored in the first database of the source system;

determine a set of differences between the first set of table metadata and the second set of table metadata; and

generate a set of instructions based on the set of differences,

wherein adapting the set of application tables to the higher upgrade version comprises executing the set of instructions.

13. The system of claim 11 , wherein the instructions further cause the at least one processing unit to retrieve the data from the upgrade version of the set of exchange tables stored on the source system from a machine-readable medium.

14. The system of claim 13 , wherein the instructions further cause the at least one processing unit to retrieve the data from the upgrade version of the set of shadow tables stored on the source system from the second machine-readable medium.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 5, 2018
From: HOPRICH, WIELAND
To: SAP SE
Reel/Frame 045990/0387 →
Continuity (1)
Related Publication 20190370405A1 · Dec 5, 2019