Solution to generate a scriptset for an automated database migration

• US 9,747,311 B2
• Filed: 07/09/2013
• Issued: 08/29/2017
• 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:
  US13/937,988
• Publication Number:
  US 20150019479A1
• Time in Patent Office: 1,512 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 for preparing a migration between server systems, the method comprising:

receiving, by a migration service comprising one or more processors communicatively coupled to one or more memories, indications of a database object to be migrated from a source server system to a target server system;

analyzing, by the migration service, characteristics of the database object to be migrated, wherein the characteristics comprise a size of the database object;

based at least partially on results of the analyzing, selecting, by the migration service, a copy operation and an install operation at least in part by;

selecting the copy operation for the database object based at least partially on the characteristics and an indication of bandwidth of a communication channel between the source server system and the target server system, the copy operation selected from a copy rules list, wherein the copy operation comprises a compression operation for the database object based at least partially on the indication of the bandwidth; and

selecting the install operation for the database object based at least partially on the characteristics, the install operation selected from a install rules list;

determining, by the migration service, a schedule for the database object, the schedule based at least partially on dependencies of the database object on other objects; and

generating a script, the script defining the copy operation and the install operation for migrating the database object.

2. The method of claim 1, wherein the copy operation is selected to reduce a time to perform the copy operation.

3. The method of claim 1, wherein the copy operation is selected to reduce a resources necessary to perform the copy operation.

4. The method of claim 1, wherein the install operation is selected to reduce a time to perform the install operation.

5. The method of claim 1, wherein the install operation is selected to reduce a resources necessary to perform the install operation.

6. The method of claim 1, wherein the install operation comprises recreating the database object on the target server system.

7. The method of claim 1, further comprising defining a post processing operation for the database object, the post processing operation includes changing a structure of the database object, the post processing operation included in the script.

8. The method of claim 1, further comprising defining a post processing operation for the database object, the post processing operation includes compressing the database object, the post processing operation included in the script.

9. A system for preparing a migration between server systems, the system comprising:

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

a migration service, configured to receive indications of a database object to be migrated from a source server system to a target server system;

an object analyzer, configured to;

analyze characteristics of the database object to be migrated, wherein the characteristics comprise a size of the database object;

based at least partially on results of the analyzing, select a copy operation and an install operation at least in part by;

selecting the copy operation for the database object based at least partially on the characteristics and an indication of bandwidth of a communication channel between the source server system and the target server system, the copy operation selected from a copy rules list, wherein the copy operation comprises a compression operation for the database object based at least partially on the indication of the bandwidth;

defining a post processing operation for the database object, the post processing operation comprising compressing the database object; and

select the install operation for the database object based at least partially on the characteristics, the install operation selected from a install rules list;

a scheduler, configured to determine a schedule for the database object, the schedule based at least partially on dependencies of the database object on other objects; and

a script generator, configured to generate a script, the script defining the copy operation and the install operation for migrating the database object.

10. The system of claim 9, wherein the object analyzer is configured to select the copy operation which minimizes a time to perform the copy operation.

11. The system of claim 9, wherein the object analyzer is configured to select the copy operation which minimizes a resources necessary to perform the copy operation.

12. The system of claim 9, wherein the object analyzer is configured to select the install operation which minimizes a time to perform the install operation.

13. The system of claim 9, wherein the object analyzer is configured to select the install operation which minimizes a resources necessary to perform the install operation.

14. A computer program product residing on a non-transitory, processor-readable medium and comprising processor-readable instructions configured to cause one or more processors to:

receive indications of a database object to be migrated from a source server system to a target server system;

analyze characteristics of the database object to be migrated, wherein the characteristics comprise a size of the database object;

based at least partially on results of the analyzing, select a copy operation and an install operation at least in part by;

selecting the copy operation for the database object based at least partially on the characteristics and an indication of bandwidth of a communication channel between the source server system and the target server system, the copy operation selected from a copy rules list, wherein the copy operation comprises a compression operation for the database object based at least partially on the indication of the bandwidth;

defining a post processing operation for the database object, the post processing operation comprising compressing the database object; and

selecting the install operation for the database object based at least partially on the characteristics, the install operation selected from a install rules list;

determine a schedule for the database object, the schedule based at least partially on dependencies of the database object on other objects; and

generate a script, the script defining the copy operation and the install operation for migrating the database object.

15. The computer program product of claim 14, wherein the copy operation is selected to minimize a time to perform the copy operation.

16. The computer program product of claim 14, wherein the copy operation is selected to minimize a resources necessary to perform the copy operation.

17. The computer program product of claim 14, wherein the install operation is selected to minimize a time to perform the install operation.

18. The computer program product of claim 14, wherein the install operation is selected to minimize a resources necessary to perform the install operation.

19. The computer program product of claim 14, wherein the install operation comprises recreating the database object on the target server system.

20. The computer program product of claim 14, further comprising instructions configured to cause one or more processors to define a post processing operation for the database object, wherein the post processing operation includes changing a structure of the database object, the post processing operation included in the script.