Automated database migration architecture

Patent metadata

Field	Value
Publication number	US-2018293233-A1
Application number	US-201816003557-A
Country	US
Kind code	A1
Filing date	Jun 8, 2018
Priority date	Jul 9, 2013
Publication date	Oct 11, 2018
Grant date	—

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.

First claim

What is claimed is:

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 received from the cloud-based database modeling service; 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 received from the cloud-based database modeling service.

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 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 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 received from the cloud-based database modeling service, 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 received from the cloud-based database modeling service; 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 o

Assignees

• Oracle Int Corp

Inventors

• Higginson Antony
• Masterson John
• Fitzpatrick Sean
• Robertshaw Peter
• Spiegelberg Elmar
• Buhne Stephan
• Weick Michael
• Balch Nick
• Popescu Florin

Classifications

• G06F16/214 Primary

  Database migration support · CPC title

• G06F17/303 Primary

  Physics · mapped topic