Copy procedure to reduce downtime for a source system
AssigneeSap SE
InventorWulf Kruempelmann
Life of this patent
Estimating the term…
Abstract
A system, a method and a computer program product for performing a copy procedure are disclosed. A copy procedure that copies a table in a plurality of tables stored at a source system to a target system is initiated. At least one table in a plurality of tables stored at the source system is selected for copying from the source system to the target system. A trigger table containing at least one trigger is generated. The trigger indicates at least one change made to the at least one selected table. The trigger table is copied from the source system to the target system. The selected table is copied from the source system to the target system. Using the copied trigger table, changes are applied to the table copied to the target system.
Claims15
A computer-implemented method, comprising:
- initiating a copy procedure that copies at least one table in a plurality of tables stored at a source system to a target system;
- selecting at least one table in a plurality of tables stored at the source system for copying from the source system to the target system;
- generating a trigger table containing at least one trigger, the trigger being indicative of at least one change made to the at least one selected table;
- copying the trigger table from the source system to the target system;
- copying the at least one selected table from the source system to the target system and applying, based on the copied trigger table, the at least one change to the at least one table in the plurality of tables stored at the target system;
- and
- deleting the trigger table after the at least one change is applied to the at least one table at the target system;
- wherein the at least one of the initiating, the selecting, the generating, the copying the trigger table, the copying the at least one table from the source system to the target system, and deleting is performed using at least one process of at least one computing system.
A system comprising:
- at least one programmable processor;
- and
- a machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
- initiating a copy procedure that copies at least one table in a plurality of tables stored at a source system to a target system;
- selecting at least one table in a plurality of tables stored at the source system for copying from the source system to the target system;
- generating a trigger table containing at least one trigger, the trigger being indicative of at least one change made to the at least one selected table;
- copying the trigger table from the source system to the target system;
- copying the at least one selected table from the source system to the target system and applying, based on the copied trigger table, the at least one change to the at least one table in the plurality of tables stored at the target system;
- and
- deleting the trigger table after the at least one change is applied to the at least one table at the target system.
A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
- initiating a copy procedure that copies at least one table in a plurality of tables stored at a source system to a target system;
- selecting at least one table in a plurality of tables stored at the source system for copying from the source system to the target system;
- generating a trigger table containing at least one trigger, the trigger being indicative of at least one change made to the at least one selected table;
- copying the trigger table from the source system to the target system;
- copying the at least one selected table from the source system to the target system and applying, based on the copied trigger table, the at least one change to the at least one table in the plurality of tables stored at the target system;
- and
- deleting the trigger table after the at least one change is applied to the at least one table at the target system.
Dependencies are inferred from the claim text.