AUTOMATED DATABASE MIGRATION ARCHITECTURE

• US 20150019488A1
• Filed: 07/09/2013
• Published: 01/15/2015
• Est. Priority Date: 07/09/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: HIGGINSON, ANTONY, MASTERSON, JOHN, FITZPATRICK, SEAN, ROBERTSHAW, PETER, BALCH, NICK, POPESCU, FLORIN, SPIEGELBERG, ELMAR, BUHNE, STEPHAN, WEICK, MICHAEL
• Granted Patent: US 9,996,562 B2
• Time in Patent Office: Days
• US Class Current: 707/634
• CPC Class Codes: G06F 16/214 Database migration support

Abstract

A method of migrating data from one or more source databases to one or more target databases may include generating a pre-migration analysis for a plurality of objects stored in the one or more source databases, and generating a plurality of migration scripts that transfer the plurality of objects from the one or more source databases to the one or more target databases. The method may also include generating a migration plan that defines an execution order for the plurality of migration scripts, and migrating the plurality of objects from the one or more source databases to one or more target databases according to the migration plan. The method may further include validating the plurality of objects on the one or more target databases.

Claims

1. A method of migrating data from one or more source databases to one or more target databases, the method comprising:

generating a pre-migration analysis for a plurality of objects stored in the one or more source databases;

generating a plurality of migration scripts that transfer the plurality of objects from the one or more source databases to the one or more target databases;

generating a migration plan that defines an execution order for the plurality of migration scripts;

migrating the plurality of objects from the one or more source databases to one or more target databases according to the migration plan; and

validating the plurality of objects on the one or more target databases.

2. The method of claim 1 wherein:

the one or more target databases comprise a single target database;

the one or more source databases comprise a plurality of source databases; and

the plurality of source databases are migrated to the single target database.

3. The method of claim 1 further comprising presenting the pre-migration analysis in a portal display of a cloud service that is remotely located from the one or more source databases and the one or more target databases.

4. The method of claim 3 further comprising presenting a post-migration report in a portal display of a cloud service that is remotely located from the one or more source databases and the one or more target databases, wherein the post-migration report comprises data resulting from the validating of the plurality of objects on the one or more target databases.

5. The method of claim 4 further comprising presenting a real-time migration report in the portal display of the cloud service, wherein the real-time migration report indicates progress while migrating the plurality of objects from the one or more source databases to one or more target databases according to the migration plan.

6. The method of claim 1 further comprising:

receiving one or more manual parameter adjustments during migration; and

altering the migration plan during the migration according to the one or more manual parameter adjustments.

7. The method of claim 1 wherein the pre-migration analysis comprises:

classifying the plurality objects, identifying installed database options, and identifying complex objects that require special handling during the migration; and

reconfiguring the complex objects such that a number of instances where the complex objects are unavailable is reduced.

8. The method of claim 1 wherein each of the plurality of objects is associated with a corresponding one of the plurality of migration scripts.

9. The method of claim 1 wherein the migration plan further defines which of the plurality of migration scripts can be executed in parallel during migration.

10. The method of claim 1 wherein the migration plan further defines an execution timing for the plurality of migration scripts.

11. The method of claim 1 wherein the pre-migration analysis comprises information received from a database modeling analysis of a cloud service that is remotely located from the one or more source databases.

12. The method of claim 1 wherein validating the plurality of objects on the one or more target databases comprises:

determining a set of invalid objects in the one or more source databases; and

determining whether the set of invalid objects were correctly migrated to the one or more target databases.

13. The method of claim 1 wherein validating the plurality of objects on the one or more target databases comprises determining whether a row count from the one or more source databases matches a row count from the one or more target databases.

14. A computer-readable memory comprising a sequence of instructions which, when executed by one or more processors, causes the one or more processors to migrate data from one or more source databases to one or more target databases by:

generating a pre-migration analysis for a plurality of objects stored in the one or more source databases;

generating a plurality of migration scripts that transfer the plurality of objects from the one or more source databases to the one or more target databases;

generating a migration plan that defines an execution order for the plurality of migration scripts;

migrating the plurality of objects from the one or more source databases to one or more target databases according to the migration plan; and

validating the plurality of objects on the one or more target databases.

15. The computer-readable memory according to claim 14 wherein the instructions further cause the one or more processors to migrate data from one or more source databases to one or more target databases by presenting the pre-migration analysis in a portal display of a cloud service that is remotely located from the one or more source databases and the one or more target databases.

16. The computer-readable memory according to claim 15 wherein the instructions further cause the one or more processors to migrate data from one or more source databases to one or more target databases by presenting a post-migration report in a portal display of a cloud service that is remotely located from the one or more source databases and the one or more target databases, wherein the post-migration report comprises data resulting from the validating of the plurality of objects on the one or more target databases.

17. The computer-readable memory according to claim 16 wherein the instructions further cause the one or more processors to migrate data from one or more source databases to one or more target databases by presenting a real-time migration report in the portal display of the cloud service, wherein the real-time migration report indicates progress while migrating the plurality of objects from the one or more source databases to one or more target databases according to the migration plan.

18. A system comprising:

one or more processors; and

a memory communicatively coupled with and readable by the one or more processors and comprising a sequence of instructions which, when executed by the one or more processors, cause the one or more processors to migrate data from one or more source databases to one or more target databases by;

generating a pre-migration analysis for a plurality of objects stored in the one or more source databases;

generating a plurality of migration scripts that transfer the plurality of objects from the one or more source databases to the one or more target databases;

generating a migration plan that defines an execution order for the plurality of migration scripts;

migrating the plurality of objects from the one or more source databases to one or more target databases according to the migration plan; and

validating the plurality of objects on the one or more target databases.

19. The system of claim 18 wherein the instructions further cause the one or more processors to migrate data from one or more source databases to one or more target databases by:

receiving one or more manual parameter adjustments during migration; and

altering the migration plan during the migration according to the one or more manual parameter adjustments.

20. The system of claim 18 wherein the pre-migration analysis comprises:

classifying the plurality objects, identifying installed database options, and identifying complex objects that require special handling during the migration; and

reconfiguring the complex objects such that a number of instances where the complex objects are unavailable is reduced.