Approaches for migrating portal objects from a source installation to a target installation

• US 7,346,627 B2
• Filed: 02/26/2004
• Issued: 03/18/2008
• Est. Priority Date: 06/25/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Shivaswamy, Arun, Jagdeesan, Balakrishnan, Ramanathan, Ravishankar
• Primary Examiner(s): Vo; Tim
• Assistant Examiner(s): GORTAYO, DANGELINO N
• Application Number:
  US10/789,838
• Publication Number:
  US 20050010919A1
• Time in Patent Office: 1,482 Days
• Field of Search: 707/103, 707/104, 707/203, 707/204, 707/103.R, 707/104.1, 707/3, 707/102
• US Class Current: 707/616
• CPC Class Codes: G06F 8/61 Installation
• CPC Class Codes: G06F 9/44505 Configuring for program initiating, e.g. using registry, configuration files

Abstract

Approaches for migrating portal objects from a source installation to a target installation are disclosed. In one embodiment, when portal objects are selected to be migrated from a source installation to a target installation, the selected portal objects can be considered to form a transport set. The metadata of the transport set itself may be stored in infrastructure tables. Then the data in the transport tables (i.e. all the application specific data), plus the metadata in the infrastructure tables (about the transport set itself) are exported and/or imported to the target installation. In an embodiment, scripts are generated to perform export and/or import functions.

Claims

1. A method of migrating objects from a source installation to a target installation, comprising:

receiving input that selects a set of migrating objects, wherein the set of migrating objects is a set of objects at the source installation that are to be migrated to the target installation;

from a first set of one or more system tables at the source installation, copying metadata that defines the selected set of migrating objects into a first set of transport tables at the source installation;

exporting the metadata from the first set of transport tables at the source installation;

importing the metadata that was exported from the first set of transport tables into a second set of transport tables at the target installation site;

merging the metadata from the second set of transport tables into a second set of one or more system tables at the target installation, wherein merging the metadata comprises transferring at least a portion of the metadata from the second set of transport tables into the second set of one or more system tables; and

migrating the set of migrating objects into the target installation.

2. The method of claim 1, wherein:

the step of exporting includes creating a dump file by invoking an export utility of a database server that manages a database containing the first set of system tables; and

the step of importing includes copying data from the dump file into the section set of system tables by invoking an import utility of a database server that manages a database containing the second set of system tables.

3. The method of claim 1, further comprising generating a script file which, when executed in a first mode causes performance of the step of exporting, and when executed in a second mode causes performance of the step of importing.

4. The method of claim 1, wherein:

the objects are application components created for an application by an application design tool associated with the first installation; and

after the step merging, accessing the application components using an application design tool associated with the second installation.

5. The method of claim 1 wherein the first set of transport tables are mirrors of the first set of system tables, and include one or more columns in addition to the columns of the first set of system tables.

6. The method of claim 1 wherein the second set of transport tables are mirrors of the second set of system tables, and include one or more columns in addition to the columns of the second set of system tables.

7. The method of claim 1 wherein the step of merging includes resolving inconsistencies between

metadata being copied into the second set of system tables from the second set of transport tables, and

metadata that already exists in said second set of system tables.

8. The method of claim 1 wherein:

one or more objects in the set of migrating objects have dependencies relative to a set of one or more other objects that have not been selected by the input;

the method further comprises the steps of automatically identifying the set of one or more other objects upon which the migrating objects depend; and

migrating from the first installation to the second installation the set of other objects along with the set of migrating objects.

9. The method of claim 1, wherein the one or more system tables at the source installation comprise metadata pertaining to the set of migrating objects, wherein the set of migrating objects were created by an application design tool.

10. The method of claim 1, further comprising merging the set of migrating objects with pre-existing data in the target installation in accordance with a specified mode that dictates how the set of migrating objects and the pre-existing data are to be reconciled.

11. A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the steps of:

receiving input that selects a set of migrating objects, wherein the set of migrating objects is a set of objects at the source installation that are to be migrated to the target installation;

from a first set of one or more system tables at the source installation, copying metadata that defines the selected set of migrating objects into a first set of transport tables at the source installation;

exporting the metadata from the first set of transport tables at the source installation;

importing the metadata that was exported from the first set of transport tables into a second set of transport tables at the target installation site;

merging the metadata from the second set of transport tables into a second set of one or more system tables at the target installation, wherein merging the metadata comprises transferring at least a portion of the metadata from the second set of transport tables into the second set of one or more system tables; and

migrating the set of migrating objects into the target installation.

12. A computer-readable storage medium as recited in claim 11, wherein

the instructions which, when executed by one or more processors, causes the one or more processors to perform the step of exporting include one or more sequences of instructions which, when executed by the one or more processors, causes the one or more processors to perform the step of creating a dump file by invoking an export utility of a database server that manages a database containing the first set of system tables;

and

the instructions which, when executed by the one or more processors, cause the one or more processors to perform step of importing include one or more sequences of instructions which, when executed by the one or more processors, causes the one or more processors to perform step of copying data from the dump file into the section set of system tables by invoking an import utility of a database server that manages a database containing the second set of system tables.

13. A computer-readable storage medium as recited in claim 11, wherein the instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of generating a script file which, when executed in a first mode causes performance of the step of exporting, and when executed in a second mode causes performance of the step of importing.

14. A computer-readable storage medium as recited in claim 11, wherein the objects are application components created for an application by an application design tool associated with the first installation;

and wherein the instructions which, when executed by one or more processors, cause the one or more processors to perform, after the step merging, the step of, accessing the application components using an application design tool associated with the second installation.

15. A computer-readable storage medium as recited in claim 11, wherein the first set of transport tables are mirrors of the first set of system tables, and include one or more columns in addition to the columns of the first set of system table.

16. A computer-readable storage medium as recited in claim 11, wherein the second set of transport tables are mirrors of the second set of system tables, and include one or more columns in addition to the columns of the second set of system tables.

17. A computer-readable storage medium as recited in claim 11, wherein the instructions which, when executed by one or more processors, cause the one or more processors to perform the step of merging include one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the step of resolving inconsistencies between:

metadata being copied into the second set of system tables from the second set of transport tables, and

metadata that already exists in said second set of system tables.

18. A computer-readable storage medium as recited in claim 11, wherein one or more objects in the set of migrating objects have dependencies relative to a set of one or more other objects that have not been selected by the input;

and

carrying one or more further sequences of instructions which, when executed by the one or more processors, causes the one or more processors to perform the step of automatically

identifying the set of one or more other objects upon which the migrating objects depend; and

migrating from the first installation to the second installation the set of other objects along with the set of migrating objects.

19. A computer-readable storage medium as recited in claim 11, wherein the one or more system tables at the source installation comprise metadata pertaining to the set of migrating objects, wherein the set of migrating objects were created by an application design tool.

20. A computer-readable storage medium as recited in claim 11, carrying one or more further sequences of instructions which, when executed by the one or more processors, causes the one or more processors to perform the step of merging the set of migrating objects with pre-existing data in the target installation in accordance with a specified mode that dictates how the set of migrating objects and the pre-existing data are to be reconciled.