Solution to generate a scriptset for an automated database migration

• US 10,540,335 B2
• Filed: 08/07/2017
• Issued: 01/21/2020
• Est. Priority Date: 07/09/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Buehne, Stephan, Spiegelberg, Elmar
• Primary Examiner(s): Chbouki, Tarek
• Application Number:
  US15/670,473
• Publication Number:
  US 20170337193A1
• Time in Patent Office: 897 Days
• CPC Class Codes: G06F 16/214 Database migration support

Abstract

The migration of a database may be accomplished, at least in part, by careful preparation and analysis of the database objects prior to migration. Migration may be performed more timely, efficiently, and reliably if the source database and its objects are first analyzed to determine the properties of the data, relationships, dependencies, and the like. The length of time of the copying and installation is reduced may selecting appropriate operations for different object types.

Claims

1. A method to facilitate a migration between systems, the method comprising:

receiving, by a migration service, indications of a set of database objects to be migrated from a source system to a target system, where the migration service comprises;

one or more memories, and

one or more processors communicatively coupled to the one or more memories;

analyzing, by the migration service, the set of database objects to be migrated to determine one or more dependencies of the set of database objects based at least partially on results of the analyzing, the one or more dependencies comprising one or more types of the database objects in the set of database objects dependent on an index that references at least one database object of the set of database objects;

based at least partially on the results of the analyzing, selecting, by the migration service, one or more copy operations for the set of database objects and one or more install operations for the set of database objects at least in part by querying a plurality of copy rules and a plurality of install rules to return the one or more copy operations and the one or more install operations that are defined for the one or more types of database objects;

determining, by the migration service, an order for the one or more copy operations and the one or more install operations, where;

copying and installing particular database objects of the set of database objects is specified according to the order, and

the order is based at least partially on the one or more dependencies of the set of database objects; and

generating at least one script, the at least one script defining the one or more copy operations and the one or more install operations for migrating the set of database objects according to the order.

2. The method of claim 1, wherein the order specifies copying or installing a first subset of the set of database objects only after a second subset of the set of database objects has been copied and installed.

3. The method of claim 1, wherein the order specifies copying or installing a first subset of the set of database objects in parallel with a second subset of the set of database objects has been copied and installed.

4. The method of claim 1, further comprising:

based at least in part on the order determined and the one or more dependencies of the set of database objects, building, by the migration service, a schedule defining an order of execution for the at least one script;

wherein the at least one script corresponds to a plurality of scripts, and execution of plurality of scripts is specified according to the order of execution.

5. The method of claim 4, wherein the order of execution for the plurality of scripts specifies parallel execution of at least two scripts of the plurality of scripts.

6. The method of claim 1, wherein the one or more copy operations are selected to reduce:

one or more copy performance times of the one or more copy operations; and

/or

resources necessary to perform the one or more copy operations.

7. The method of claim 6, wherein the one or more install operations comprise recreating the set of database objects on the target system, and the one or more install operations are selected to reduce:

one or more install performance times of the one or more install operations; and

/or

the resources necessary to perform the one or more install operations.

8. A system comprising:

one or more processors; and

a memory communicatively coupled with and readable by the one or more processors and having stored therein instructions which, when executed by the one or more processors, cause the one or more processors to perform;

receiving indications of a set of database objects to be migrated from a source system to a target system;

analyzing the set of database objects to be migrated to determine one or more dependencies of the set of database objects based at least partially on results of the analyzing, the one or more dependencies comprising one or more types of the database objects in the set of database objects dependent on an index that references at least one database object of the set of database objects;

based at least partially on the results of the analyzing, selecting one or more copy operations for the set of database objects and one or more install operations for the set of database objects at least in part by querying a plurality of copy rules and a plurality of install rules to return the one or more copy operations and the one or more install operations that are defined for the one or more types of database objects;

determining an order for the one or more copy operations and the one or more install operations, where;

copying and installing particular database objects of the set of database objects is specified according to the order, and

the order is based at least partially on the one or more dependencies of the set of database objects; and

generating at least one script, the at least one script defining the one or more copy operations and the one or more install operations for migrating the set of database objects according to the order.

9. The system of claim 8, wherein the order specifies copying or installing a first subset of the set of database objects only after a second subset of the set of database objects has been copied and installed.

10. The system of claim 8, wherein the order specifies copying or installing a first subset of the set of database objects in parallel with a second subset of the set of database objects has been copied and installed.

11. The system of claim 8, the one or more processors further to perform:

based at least in part on the order determined and the one or more dependencies of the set of database objects, building a schedule defining an order of execution for the at least one script;

wherein the at least one script corresponds to a plurality of scripts, and execution of plurality of scripts is specified according to the order of execution.

12. The system of claim 11, wherein the order of execution for the plurality of scripts specifies parallel execution of at least two scripts of the plurality of scripts.

13. The system of claim 12, wherein the one or more copy operations are selected to reduce:

one or more copy performance times of the one or more copy operations; and

/or

resources necessary to perform the one or more copy operations.

14. The system of claim 13, wherein the one or more install operations comprise recreating the set of database objects on the target system, and the one or more install operations are selected to reduce:

one or more install performance times of the one or more install operations; and

/or

the resources necessary to perform the one or more install operations.

15. One or more non-transitory, machine-readable media having machine-readable instructions thereon, which, when executed by one or more processing devices, cause the one or more processing devices to perform:

one or more processors; and

a memory communicatively coupled with and readable by the one or more processors and having stored therein instructions which, when executed by the one or more processors, cause the one or more processors to perform;

receiving indications of a set of database objects to be migrated from a source system to a target system;

analyzing the set of database objects to be migrated to determine one or more dependencies of the set of database objects based at least partially on results of the analyzing, the one or more dependencies comprising one or more types of the database objects in the set of database objects dependent on an index that references at least one database object of the set of database objects;

based at least partially on the results of the analyzing, selecting one or more copy operations for the set of database objects and one or more install operations for the set of database objects at least in part by querying a plurality of copy rules and a plurality of install rules to return the one or more copy operations and the one or more install operations that are defined for the one or more types of database objects;

determining an order for the one or more copy operations and the one or more install operations, where;

copying and installing particular database objects of the set of database objects is specified according to the order, and

the order is based at least partially on the one or more dependencies of the set of database objects; and

generating at least one script, the at least one script defining the one or more copy operations and the one or more install operations for migrating the set of database objects according to the order.

16. The one or more non-transitory, machine-readable media of claim 15, wherein the order specifies copying or installing a first subset of the set of database objects only after a second subset of the set of database objects has been copied and installed.

17. The one or more non-transitory, machine-readable media of claim 15, wherein the order specifies copying or installing a first subset of the set of database objects in parallel with a second subset of the set of database objects has been copied and installed.

18. The one or more non-transitory, machine-readable media of claim 15, wherein the machine-readable instructions further cause the one or more processing devices to perform:

based at least in part on the order determined and the one or more dependencies of the set of database objects, building a schedule defining an order of execution for the at least one script;

wherein the at least one script corresponds to a plurality of scripts, and execution of plurality of scripts is specified according to the order of execution.

19. The one or more non-transitory, machine-readable media of claim 18, wherein the order of execution for the plurality of scripts specifies parallel execution of at least two scripts of the plurality of scripts.

20. The one or more non-transitory, machine-readable media of claim 19, wherein the one or more copy operations are selected to reduce:

one or more copy performance times of the one or more copy operations; and

/or

resources necessary to perform the one or more copy operations.