MINIMIZING DOWNTIME IN MIGRATING CONTENT OF DATABASES SYSTEMS

• US 20180137113A1
• Filed: 11/16/2016
• Published: 05/17/2018
• Est. Priority Date: 11/16/2016
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Kurz, Saskia, Schroeder, Alexander, Loetzer, Thomas, Paskamp, Marco, Welk, Kerstin, Fei, Martin, Folkerts, Enno, Bautz, Christoph, Heinrich, Tilo
• Granted Patent: US 11,829,337 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46

Abstract

Methods, systems, and computer-readable storage media for executing a first application on a source system during production use of the source system, providing a second application on a target system, during the production use of the source system: migrating data from the source system to the target system based on a catalog delta, and a data delta, each of the catalog delta, and the data delta being periodically determined, and determining whether a completion time exceeds a threshold time, the completion time being determined based on a last-determined data delta, and, in response to determining that the completion time does not exceed the threshold time: halting production use of the source system, and completing migration to the target system based on the last-determined data delta.

Claims

1. A computer-implemented method for minimizing downtime during migration from a source system to a target system, the method being executed using one or more processors and comprising:

executing, by the one or more processors, a first application on the source system during production use of the source system;

providing, by the one or more processors, a second application on the target system;

during the production use of the source system;

migrating data from the source system to the target system based on a catalog delta, and a data delta, each of the catalog delta, and the data delta being periodically determined, and

determining whether a completion time exceeds a threshold time, the completion time being determined based on a last-determined data delta; and

in response to determining that the completion time does not exceed the threshold time;

halting production use of the source system, and

completing migration to the target system based on the last-determined data delta.

2. The method of claim 1, wherein the catalog delta provides one or more differences between a database catalog of the source system, and a database catalog of the target system.

3. The method of claim 1, wherein the data delta provides one or more differences between data stored in a database of the source system, and data stored in a database of the target system.

4. The method of claim 1, wherein completing migration to the target system based on the last-determined data delta comprises:

migrating data of the source system indicated by the last-determined data delta to the target system;

determining a final catalog delta; and

executing one or more final extraction steps that are provided based on the final catalog delta.

5. The method of claim 4, wherein completing migration to the target system based on the last-determined data delta further comprises applying updates indicated by the last-determined data delta to data stored in the target system.

6. The method of claim 1, wherein the completion time is determined based on one or more of data of the source system to-be-migrated to the target system, and at least one update to data stored in the target system, as indicated by the last-determined data delta.

7. The method of claim 1, further comprising using the target system for production use of the second application after completion of the migration.

8. A non-transitory computer-readable storage medium coupled to one or more processors and having instructions stored thereon which, when executed by the one or more processors, cause the one or more processors to perform operations for minimizing downtime during migration from a source system to a target system, the operations comprising:

executing a first application on the source system during production use of the source system;

providing a second application on the target system;

during the production use of the source system;

migrating data from the source system to the target system based on a catalog delta, and a data delta, each of the catalog delta, and the data delta being periodically determined, and

determining whether a completion time exceeds a threshold time, the completion time being determined based on a last-determined data delta; and

in response to determining that the completion time does not exceed the threshold time;

halting production use of the source system, and

completing migration to the target system based on the last-determined data delta.

9. The computer-readable storage medium of claim 8, wherein the catalog delta provides one or more differences between a database catalog of the source system, and a database catalog of the target system.

10. The computer-readable storage medium of claim 8, wherein the data delta provides one or more differences between data stored in a database of the source system, and data stored in a database of the target system.

11. The computer-readable storage medium of claim 8, wherein completing migration to the target system based on the last-determined data delta comprises:

migrating data of the source system indicated by the last-determined data delta to the target system;

determining a final catalog delta; and

executing one or more final extraction steps that are provided based on the final catalog delta.

12. The computer-readable storage medium of claim 11, wherein completing migration to the target system based on the last-determined data delta further comprises applying updates indicated by the last-determined data delta to data stored in the target system.

13. The computer-readable storage medium of claim 8, wherein the completion time is determined based on one or more of data of the source system to-be-migrated to the target system, and at least one update to data stored in the target system, as indicated by the last-determined data delta.

14. The computer-readable storage medium of claim 8, wherein operations further comprise using the target system for production use of the second application after completion of the migration.

15. A system, comprising:

a computing device; and

a computer-readable storage device coupled to the computing device and having instructions stored thereon which, when executed by the computing device, cause the computing device to perform operations for minimizing downtime during maintenance procedures to an application, the operations comprising;

executing a first application on the source system during production use of the source system;

providing a second application on the target system;

during the production use of the source system;

migrating data from the source system to the target system based on a catalog delta, and a data delta, each of the catalog delta, and the data delta being periodically determined, and

determining whether a completion time exceeds a threshold time,

the completion time being determined based on a last-determined data delta; and

in response to determining that the completion time does not exceed the threshold time;

halting production use of the source system, and

completing migration to the target system based on the last-determined data delta.

16. The system of claim 15, wherein the catalog delta provides one or more differences between a database catalog of the source system, and a database catalog of the target system.

17. The system of claim 15, wherein the data delta provides one or more differences between data stored in a database of the source system, and data stored in a database of the target system.

18. The system of claim 15, wherein completing migration to the target system based on the last-determined data delta comprises:

migrating data of the source system indicated by the last-determined data delta to the target system;

determining a final catalog delta; and

executing one or more final extraction steps that are provided based on the final catalog delta.

19. The system of claim 18, wherein completing migration to the target system based on the last-determined data delta further comprises applying updates indicated by the last-determined data delta to data stored in the target system.

20. The system of claim 15, wherein the completion time is determined based on one or more of data of the source system to-be-migrated to the target system, and at least one update to data stored in the target system, as indicated by the last-determined data delta.