Method and system for migrating content between enterprise content management systems

• US 10,248,670 B1
• Filed: 06/05/2013
• Issued: 04/02/2019
• Est. Priority Date: 03/14/2013
• Status: Active Grant

• Current Assignee: Open Text Corporation
• Original Assignee: Open Text Corporation
• Inventors: Mohen, Michael T., Dyde, Christopher
• Primary Examiner(s): Alam, Hosain T
• Assistant Examiner(s): Allen, Nicholas E
• Application Number:
  US13/910,342
• Time in Patent Office: 2,127 Days
• Field of Search: None
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 10/0631 Resource planning, allocation, distributing or scheduling for enterprises or organisations

Abstract

Migrating content between enterprise content management systems is described. A source object identifier is identified for metadata tables for content for a source enterprise content management system, based on a migration job definition. The metadata tables are retrieved from the source enterprise content management system, based on the source object identifier. A target object identifier is identified for a target enterprise content management system, based on the metadata tables and the migration job definition. An object identifier map is created that maps the source object identifier to the target object identifier. The metadata tables are stored to the target enterprise content management system, based on the object identifier map. The content for the source enterprise content management system is retrieved. The content is stored as content for the target enterprise content management system.

Claims

1. A system for migrating content between enterprise content management systems, the system comprising:

a processor; and

a processor-based application that is executable by the processor to;

based on a migration job definition, execute a first remote procedure call to a source database management system associated with a source enterprise content management system to directly interact with a source database at a level of the source database to identify a source object identifier that is a primary key that uniquely identifies a plurality of source metadata tables stored in the source enterprise content management system for content stored in the source enterprise content management system;

retrieve the plurality of source metadata tables from the source enterprise content management system, based on using the source object identifier as the primary key that uniquely identifies the plurality of source metadata tables;

execute a second remote procedure call to a target database management system associated with a target enterprise content management system to identify a target object identifier based on the plurality of source metadata tables and the migration job definition, wherein the target object identifier is a placeholder object identifier in the target enterprise content management system for the source metadata tables to be migrated;

create an object identifier map that maps the source object identifier that functions, at the source enterprise content management system, as the primary key that uniquely identifies the plurality of source metadata tables to the target object identifier that is the placeholder object identifier in the target enterprise content management system for the source metadata tables to be migrated;

store the plurality of source metadata tables to the target enterprise content management system, based on the object identifier map;

retrieve the content for the source enterprise content management system; and

store the content as content for the target enterprise content management system.

2. The system of claim 1, wherein the plurality of source metadata tables include a pointer to the content, a single value table, and a repeat value table, wherein the repeat value table specifies multiple keywords for each content item included in the content.

3. The system of claim 1, wherein retrieving the plurality of source metadata tables from the source enterprise content management system comprises storing the metadata tables in a NoSQL non-relational database hosted in a staging environment.

4. The system of claim 1, wherein storing the plurality of source metadata tables to the target enterprise content management system comprises retrieving the plurality of source metadata tables from a NoSQL non-relational database hosted in a staging environment.

5. The system of claim 1, wherein the processor-based application is further executable by the processor to create the migration job definition, define users associated with the content, and define roles associated with the content.

15. The system of claim 1, wherein retrieving the plurality of source metadata tables from the source enterprise content management system includes retrieving the plurality of source metadata tables from the source enterprise content management system via an object view, on a table-by-table basis.

6. A computer-implemented method for migrating content between enterprise content management systems, the method comprising:

based on a migration job definition, executing a first remote procedure call to a source database management system associated with a source enterprise content management system to directly interact with a source database at a level of the source database to identify a source object identifier that is a primary key that uniquely identifies a plurality of source metadata tables stored in the source enterprise content management system for content stored in the source enterprise content management system;

retrieving the plurality of source metadata tables from the source enterprise content management system, based on using the source object identifier as the primary key that uniquely identifies the plurality of source metadata tables;

executing a second remote procedure call to a target database management system associated with a target enterprise content management system to identify a target object identifier based on the plurality of source metadata tables and the migration job definition, the target object identifier serving as a placeholder object identifier in the target enterprise content management system for the source metadata tables to be migrated;

creating an object identifier map that maps the source object identifier that functions, at the source enterprise content management system, as the primary key that uniquely identifies the plurality of source metadata tables to the target object identifier that serves as the placeholder object identifier in the target enterprise content management system for the source metadata tables to be migrated;

storing the plurality of source metadata tables to the target enterprise content management system, based on the object identifier map;

retrieving the content for the source enterprise content management system; and

storing the content as content for the target enterprise content management system.

7. The computer-implemented method of claim 6, wherein the plurality of source metadata tables include a pointer to the content, a single value table, and a repeat value table.

8. The computer-implemented method of claim 6, wherein retrieving the plurality of source metadata tables from the source enterprise content management system comprises storing the plurality of source metadata tables in a NoSQL non-relational database hosted in a staging environment.

9. The computer-implemented method of claim 6, wherein storing the plurality of source metadata tables to the target enterprise content management system comprises retrieving the plurality of source metadata tables from a NoSQL non-relational database hosted in a staging environment.

10. The computer-implemented method of claim 6, wherein the method further comprises creating the migration job definition, defining users associated with the content, and defining roles associated with the content.

16. The computer-implemented method of claim 6, wherein retrieving the plurality of source metadata tables from the source enterprise content management system includes retrieving the plurality of source metadata tables from the source enterprise content management system via an object view, on a table-by-table basis.

11. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein, the computer-readable program code executable by one or more processors to implement a method for migrating content between enterprise content management systems, the method comprising:

based on a migration job definition, executing a first remote procedure call to a source database management system associated with a source enterprise content management system to directly interact with a source database at a level of the source database to identify a source object identifier that is a primary key that uniquely identifies a plurality of source metadata tables stored in the source enterprise content management system for content stored in the source enterprise content management system;

retrieving the plurality of source metadata tables from the source enterprise content management system, based on using the source object identifier as the primary key that uniquely identifies the plurality of source metadata tables;

executing a second remote procedure call to a target database management system associated with a target enterprise content management system to identify a target object identifier based on the plurality of source metadata tables and the migration job definition, the target object identifier serving as a placeholder object identifier in the target enterprise content management system for the source metadata tables to be migrated;

creating an object identifier map that maps the source object identifier that functions, at the source enterprise content management system, as the primary key that uniquely identifies the plurality of source metadata tables to the target object identifier that serves as the placeholder object identifier in the target enterprise content management system for the source metadata tables to be migrated;

storing the plurality of source metadata tables to the target enterprise content management system, based on the object identifier map;

retrieving the content for the source enterprise content management system; and

storing the content as content for the target enterprise content management system.

12. The computer program product of claim 11, wherein the plurality of source metadata tables include a pointer to the content, a single value table, and a repeat value table.

13. The computer program product of claim 11, wherein retrieving the plurality of source metadata tables from the source enterprise content management system comprises storing the plurality of source metadata tables in a NoSQL non-relational database hosted in a staging environment, and wherein storing the plurality of source metadata tables to the target enterprise content management system comprises retrieving the plurality of source metadata tables from the NoSQL non-relational database.

14. The computer program product of claim 11, wherein the method further comprises creating the migration job definition, defining users associated with the content, and defining roles associated with the content.

17. The computer program product of claim 11, wherein retrieving the plurality of source metadata tables from the source enterprise content management system includes retrieving the plurality of source metadata tables from the source enterprise content management system via an object view, on a table-by-table basis.