Dynamic migration script management
First Claim
1. A method for managing migration between server systems, the method comprising:
- receiving, by a scheduler computer system, 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, wherein the source server system is online and processing database requests during the migration of the database system;
determining, by the scheduler computer system, an execution order for the plurality of migration scripts 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;
initiating, by the scheduler computer system, execution of a first migration script of the plurality of migration scripts according to the determined execution order, wherein the first migration script causes copying of a first database object of the plurality of database objects from the source server system to the target server system;
determining, by the scheduler computer system, an amount of available resources at the source server system based on the database requests processed while the source server system is online;
modifying, by the scheduler computer system, the execution order for the plurality of migration scripts based on the amount of available resources at the source server system, wherein the amount of available resources at the source server system is based on the database requests processed while the source server system is online; and
initiating, by the scheduler computer system, execution of a second migration script of the plurality of migration scripts according to the modified execution order, wherein the second migration script causes copying of a second database object of the plurality of database objects from the source server system to the target server system.
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.
-
Citations
20 Claims
-
1. A method for managing migration between server systems, the method comprising:
-
receiving, by a scheduler computer system, 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, wherein the source server system is online and processing database requests during the migration of the database system; determining, by the scheduler computer system, an execution order for the plurality of migration scripts 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; initiating, by the scheduler computer system, execution of a first migration script of the plurality of migration scripts according to the determined execution order, wherein the first migration script causes copying of a first database object of the plurality of database objects from the source server system to the target server system; determining, by the scheduler computer system, an amount of available resources at the source server system based on the database requests processed while the source server system is online; modifying, by the scheduler computer system, the execution order for the plurality of migration scripts based on the amount of available resources at the source server system, wherein the amount of available resources at the source server system is based on the database requests processed while the source server system is online; and initiating, by the scheduler computer system, execution of a second migration script of the plurality of migration scripts according to the modified execution order, wherein the second migration script causes copying of a second database object of the plurality of database objects from the source server system to the target server system. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system for managing migration between server systems, the system comprising:
-
a source server system; a target server system; and a scheduler computer system, comprising; one or more processors; and a memory communicatively coupled with and readable by the one or more processors and having stored therein processor-readable instructions which, when executed by the one or more processors, cause the one or more processors to; receive indications of a plurality of migration scripts to be executed during a migration of a database system from the source server system to the target server system, wherein the source server system is online and processing database requests during the migration of the database system; determine an execution order for the plurality of migration scripts 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; initiate execution of a first migration script of the plurality of migration scripts according to the determined execution order, wherein the first migration script causes copying of a first database object of the plurality of database objects from the source server system to the target server system; determine an amount of available resources at the source server system based on the database requests processed while the source server system is online; modify the execution order for the plurality of migration scripts based on the amount of available resources at the source server system, wherein the amount of available resources at the source server system is based on the database requests processed while the source server system is online; and initiate execution of a second migration script of the plurality of migration scripts according to the modified execution order, wherein the second migration script causes copying of a second database object of the plurality of database objects from the source server system to the target server system. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A non-transitory processor-readable medium for managing migration between server systems, comprising processor-readable instructions configured to cause one or more processors to:
-
receive 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, wherein the source server system is online and processing database requests during the migration of the database system; determine an execution order for the plurality of migration scripts 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; initiate execution of a first migration script of the plurality of migration scripts according to the determined execution order, wherein the first migration script causes copying of a first database object of the plurality of database objects from the source server system to the target server system; determine an amount of available resources at the source server system based on the database requests processed while the source server system is online; modify the execution order for the plurality of migration scripts based on the amount of available resources at the source server system, wherein the amount of available resources at the source server system is based on the database requests processed while the source server system is online; and initiate execution of a second migration script of the plurality of migration scripts according to the modified execution order, wherein the second migration script causes copying of a second database object of the plurality of database objects from the source server system to the target server system.
-
Specification