Automated database migration architecture

• US 10,691,654 B2
• Filed: 06/08/2018
• Issued: 06/23/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: Higginson, Antony, Masterson, John, Fitzpatrick, Sean, Robertshaw, Peter, Spiegelberg, Elmar, Buhne, Stephan, Weick, Michael, Balch, Nick, Popescu, Florin
• Primary Examiner(s): Oberly, Van H
• Application Number:
  US16/003,557
• Publication Number:
  US 20180293233A1
• Time in Patent Office: 746 Days
• 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:

receiving, at a cloud-based system, data associated with the one or more source databases and the one or more target databases;

generating, at the cloud-based system, a plurality of migration scripts that transfer a plurality of objects from the one or more source databases to the one or more target databases, based on the data associated with the one or more source databases and the one or more target databases;

displaying, through a user interface, a migration plan comprising;

an order in which the plurality of migration scripts will be executed during migration to minimize downtime during migration of the one or more source databases; and

indications of which of the plurality of migration scripts can be executed in parallel;

while migrating the plurality of objects, executing a number of migration scripts in parallel, according to the migration plan;

while migrating the plurality of objects, receiving an input through the user interface adjusting an amount of parallel processing during the migration; and

while migrating the plurality of objects, scaling up or down the number of migration scripts executed in parallel based on the input received through the user interface.

2. The method of claim 1, wherein the migration plan displayed through the user interface further comprises a graph illustrating:

an amount of data in the one or more source databases that can be compressed on the one or more target databases; and

an amount of data in the one or more source databases that cannot be compressed on the one or more target databases.

3. The method of claim 2, wherein the migration plan displayed through the user interface further comprises a table illustrating how much of the amount of data in the one or more source databases that can be compressed on the one or more target databases includes compressed indexes.

4. The method of claim 1, wherein the migration plan displayed through the user interface further comprises a graph illustrating a total number of import/export jobs in the migration plan.

5. The method of claim 1, wherein the migration plan displayed through the user interface further comprises a graph illustrating:

a number of tables in the one or more source databases that will be transferred by boat export/import;

a number of tables in the one or more source databases that will be transferred by datapump; and

a number of tables in the one or more source databases that will be transferred by separate scripts.

6. The method of claim 1, further comprising generating a pre-migration analysis for the plurality of objects stored in the one or more source databases based on the data associated with the one or more source databases and the one or more target databases.

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

classifying the of plurality objects, identifying installed database options, and identifying complex objects that require special handling while migrating the plurality of objects; 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 the cloud-based system is located remotely from the source databases and from the target databases and is configured to collect and analyze data from the source databases and from the target databases through a gateway.

9. The method of claim 1, wherein the migration plan further comprises timing constraints that dictate when each of the plurality of migration scripts can be executed.

10. The method of claim 1, further comprising, after migrating the plurality of objects, validating the plurality of objects on the one or more target databases.

11. 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.

12. The method of claim 1, further comprising presenting a real-time migration report through the user interface, 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.

13. 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.

14. The method of claim 1 further comprising determining, based on the data associated with the one or more source databases and the one or more target databases, which of the plurality of migration scripts can be executed in parallel during migration.

15. A non-transitory computer-readable memory comprising a sequence of instructions which, when executed by one or more processors, causes the one or more processors to perform operations comprising:

receiving, at a cloud-based system, data associated with one or more source databases and one or more target databases;

generating, at the cloud-based system, a plurality of migration scripts that transfer a plurality of objects from the one or more source databases to the one or more target databases, based on the data associated with the one or more source databases and the one or more target databases;

displaying, through a user interface, a migration plan comprising;

an order in which the plurality of migration scripts will be executed during migration to minimize downtime during migration of the one or more source databases; and

indications of which of the plurality of migration scripts can be executed in parallel;

while migrating the plurality of objects, executing a number of migration scripts in parallel, according to the migration plan;

while migrating the plurality of objects, receiving an input through the user interface adjusting an amount of parallel processing during the migration; and

while migrating the plurality of objects, scaling up or down the number of migration scripts executed in parallel based on the input received through the user interface.

16. The non-transitory computer-readable memory of claim 15, comprising additional instructions that cause the one or more processors to perform additional operations comprising presenting a post-migration report through the user interface, wherein the post-migration report comprises data resulting from validating of the plurality of objects on the one or more target databases.

17. The non-transitory computer-readable memory of claim 15, comprising additional instructions that cause the one or more processors to perform additional operations comprising presenting a real-time migration report through the user interface, 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 perform operations comprising;

receiving, at a cloud-based system, data associated with one or more source databases and one or more target databases;

generating, at the cloud-based system, a plurality of migration scripts that transfer a plurality of objects from the one or more source databases to the one or more target databases, based on the data associated with the one or more source databases and the one or more target databases;

displaying, through a user interface, a migration plan comprising;

an order in which the plurality of migration scripts will be executed during migration to minimize downtime during migration of the one or more source databases; and

indications of which of the plurality of migration scripts can be executed in parallel;

while migrating the plurality of objects, executing a number of migration scripts in parallel, according to the migration plan;

while migrating the plurality of objects, receiving an input through the user interface adjusting an amount of parallel processing during the migration; and

while migrating the plurality of objects, scaling up or down the number of migration scripts executed in parallel based on the input received through the user interface.

19. The system of claim 18, wherein the memory comprises additional instructions that cause the one or more processors to perform additional operations comprising:

determining that one or more index files for the source databases should not be copied to the target databases; and

based on the determination, instructing one or more of the target databases to generate new index files corresponding to the one or more index files not copied from the source databases.

20. The system of claim 18, wherein migrating the plurality of objects is performed in response to a customer request for data migration, and

wherein the migration plan is generated preemptively, prior to the customer request for data migration, based on the data associated with the one or more source databases and the one or more target databases.