Dynamic migration script management
First Claim
1. A method comprising:
- receiving one or more indications of a plurality of migration scripts to be executed to perform a migration of a database system from a source server system to a target server system, wherein the source server system is online and processing database requests during the migration of the database system;
determining, based on one or more factors, an execution order in which the plurality of migration scripts are to be initialized for execution;
identifying one or more first migration scripts of the plurality of migration scripts based on the execution order;
initiating execution of the one or more first migration scripts to commence the migration of the database system;
identifying one or more second migration scripts of the plurality of migration scripts scheduled to initiate execution after the one or more first migration scripts based on the execution order;
monitoring one or more processing resources available to the source server system and/or the target server system;
determining that the one or more processing resources are above a first threshold but below a second threshold;
initiating execution of one or more third migration scripts of the plurality of migration scripts out-of-order from the execution order to continue the migration of the database system based on determining that the processing resources are above the first threshold but below the second threshold, the one or more third migration scripts being initiated for execution before the one or more second migration scripts; and
rescheduling the one or more second migration scripts to be initiated for execution after the one or more third migration scripts.
1 Assignment
0 Petitions
Accused Products
Abstract
Various embodiments for managing migration between server systems are presented. Indications of a plurality of migration scripts to be executed during a migration of a database system from a source server system to a target server system may be received. An execution order for the plurality of migration scripts may be determined based upon characteristics of a plurality of database objects to be migrated using the plurality of migration scripts and characteristics of the plurality of migration scripts. Execution of a first migration script of the plurality of migration scripts may be initiated according to the determined execution order. The first migration script may cause copying of a database object of the plurality of database objects from the source server system to the target server system.
178 Citations
20 Claims
-
1. A method comprising:
-
receiving one or more indications of a plurality of migration scripts to be executed to perform a migration of a database system from a source server system to a target server system, wherein the source server system is online and processing database requests during the migration of the database system; determining, based on one or more factors, an execution order in which the plurality of migration scripts are to be initialized for execution; identifying one or more first migration scripts of the plurality of migration scripts based on the execution order; initiating execution of the one or more first migration scripts to commence the migration of the database system; identifying one or more second migration scripts of the plurality of migration scripts scheduled to initiate execution after the one or more first migration scripts based on the execution order; monitoring one or more processing resources available to the source server system and/or the target server system; determining that the one or more processing resources are above a first threshold but below a second threshold; initiating execution of one or more third migration scripts of the plurality of migration scripts out-of-order from the execution order to continue the migration of the database system based on determining that the processing resources are above the first threshold but below the second threshold, the one or more third migration scripts being initiated for execution before the one or more second migration scripts; and rescheduling the one or more second migration scripts to be initiated for execution after the one or more third migration scripts. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system comprising:
-
a processor; and a non-transitory computer-readable storage medium comprising instructions which, when executed by the processor, cause the processor to perform operations including; receiving one or more indications of a plurality of migration scripts to be executed to perform a migration of a database system from a source server system to a target server system, wherein the source server system is online and processing database requests during the migration of the database system; determining, based on one or more factors, an execution order in which the plurality of migration scripts are to be initialized for execution; identifying one or more first migration scripts of the plurality of migration scripts based on the execution order; initiating execution of the one or more first migration scripts to commence the migration of the database system; identifying one or more second migration scripts of the plurality of migration scripts scheduled to initiate execution after the one or more first migration scripts based on the execution order; monitoring one or more processing resources available to the source server system and/or the target server system; determining that the one or more processing resources are above a first threshold but below a second threshold; initiating execution of one or more third migration scripts of the plurality of migration scripts out-of-order from the execution order to continue the migration of the database system based on determining that the processing resources are above the first threshold but below the second threshold, the one or more third migration scripts being initiated for execution before the one or more second migration scripts; and rescheduling the one or more second migration scripts to be initiated for execution after the one or more third migration scripts. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A non-transitory computer-readable storage medium comprising instructions which, when executed by a processor, cause the processor to perform operations including:
-
receiving one or more indications of a plurality of migration scripts to be executed to perform a migration of a database system from a source server system to a target server system, wherein the source server system is online and processing database requests during the migration of the database system; determining, based on one or more factors, an execution order in which the plurality of migration scripts are to be initialized for execution; identifying one or more first migration scripts of the plurality of migration scripts based on the execution order; initiating execution of the one or more first migration scripts to commence the migration of the database system; identifying one or more second migration scripts of the plurality of migration scripts scheduled to initiate execution after the one or more first migration scripts based on the execution order; monitoring one or more processing resources available to the source server system and/or the target server system; determining that the one or more processing resources are above a first threshold but below a second threshold; initiating execution of one or more third migration scripts of the plurality of migration scripts out-of-order from the execution order to continue the migration of the database system based on determining that the processing resources are above the first threshold but below the second threshold, the one or more third migration scripts being initiated for execution before the one or more second migration scripts; and rescheduling the one or more second migration scripts to be initiated for execution after the one or more third migration scripts.
-
Specification