Method and system for cloning enterprise content management systems

• US 10,353,878 B1
• Filed: 06/25/2013
• Issued: 07/16/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): Nguyen, Cam Linh T
• Application Number:
  US13/926,601
• Time in Patent Office: 2,212 Days
• Field of Search: 707602, 707812
• 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

Cloning enterprise content management systems is described. A first remote procedure call is executed to a source database management system associated with a source enterprise content management system to retrieve a source object type from the source enterprise content management system. A second remote procedure call is executed to a target database management system associated with a target enterprise content management system to create a target object type in the target enterprise content management system, wherein the target object type is based on the source object type. Source metadata tables associated with the source object type are retrieved from the source enterprise content management system. The source metadata tables are stored as target metadata tables in the target enterprise content management system.

Claims

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

a processor-based application executed on a computer and configured to;

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 database at a level of the database, to retrieve a source object type from a plurality of object types stored in the source enterprise content management system, the source object type including at least one database schema and at least one relationship, and

generate a second remote procedure call, the second remote procedure call being generated based on the retrieved source object type;

execute the second remote procedure call to a target database management system associated with a target enterprise content management system to create a target object type and to store the target object type in the target enterprise content management system, wherein the target object type is created based on the source object type;

retrieve source metadata tables associated with the source object type from the source enterprise content management system, the source metadata tables containing data for objects of the source object type;

store the source metadata tables as target metadata tables in the target enterprise content management system after storing the target object type in the target enterprise content management system, the target metadata tables containing data for objects of the target object type; and

responsive to storing the source metadata tables as target metadata tables, update an index of the target enterprise content management system.

2. The system of claim 1, wherein retrieving the source metadata tables comprises executing a third remote procedure call to the source database management system.

3. The system of claim 2, wherein storing the source metadata tables as the target metadata tables comprises executing a fourth remote procedure call to the target database management system.

4. The system of claim 1, wherein the processor-based application is further configured to create the target enterprise content management system.

5. The system of claim 1, wherein the processor-based application is further configured to retrieve an audit trail from the source enterprise content management system;

and store the audit trail in the target enterprise content management system.

6. The system of claim 1, wherein the processor-based application is further configured to retrieve source content associated with the source enterprise content management system;

and

store the source content as target content associated with the target enterprise content management system.

7. The system of claim 1, wherein the processor-based application is further configured to upgrade the target enterprise content management system to a next generation enterprise content management system.

8. The system of claim 1, wherein the processor-based application is further configured to provide a target repository identifier for a target repository of the target enterprise content management system that is the same as a source repository identifier for a source repository of the source enterprise content management system.

9. The system of claim 8, wherein object identifiers for objects of the source database management system are retained for the cloning to the target enterprise content management system.

10. A computer-implemented method for cloning enterprise content management systems, the method comprising:

executing, by a computing device, a first remote procedure call to a source database management system associated with a source enterprise content management system, to directly interact with a database at a level of the database, to retrieve a source object type from a plurality of object types stored in the source enterprise content management system, the source object type including at least one database schema and at least one relationship, and

generating a second remote procedure call, the second remote procedure call being generated based on the retrieved source object type;

executing, by the computing device, the second remote procedure call to a target database management system associated with a target enterprise content management system to create a target object type and to store the target object type in the target enterprise content management system, wherein the target object type is created based on the source object type;

retrieving, by the computing device, source metadata tables associated with the source object type from the source enterprise content management system, the source metadata tables containing data for objects of the source object type;

storing, by the computing device, the source metadata tables as target metadata tables in the target enterprise content management system after storing the target object type in the target enterprise content management system, the target metadata tables containing data for objects of the target object type; and

responsive to storing the source metadata tables as target metadata tables, updating an index of the target enterprise content management system.

11. The computer-implemented method of claim 10, wherein retrieving the source metadata tables comprises executing, by the computing device, a third remote procedure call to the source database management system.

12. The computer-implemented method of claim 11, wherein storing the source metadata tables as the target metadata tables comprises executing, by the computing device, a fourth remote procedure call to the target database management system.

13. The computer-implemented method of claim 10, further comprising:

creating, by the computing device, the target enterprise content management system.

14. The computer-implemented method of claim 10, wherein the method further comprises:

retrieving, by the computing device, an audit trail from the source enterprise content management system; and

storing, by the computing device, the audit trail in the target enterprise content management system.

15. The computer-implemented method of claim 10, wherein the method further comprises:

retrieving, by the computing device, source content associated with the source enterprise content management system; and

storing, by the computing device, the source content as target content associated with the target enterprise content management system.

16. The computer-implemented method of claim 10, wherein the method further comprises upgrading, by the computing device, the target enterprise content management system to a next generation enterprise content management system.

17. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein, the computer-readable program code adapted to be executed by one or more processors to implement a method for cloning enterprise content management systems, the method comprising:

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 database at a level of the database, to retrieve a source object type from a plurality of object types stored in the source enterprise content management system, the source object type including at least one database schema and at least one relationship, and

generating a second remote procedure call, the second remote procedure call being generated based on the retrieved source object type;

executing the second remote procedure call to a target database management system associated with a target enterprise content management system to create a target object type and to store the target object type in the target enterprise content management system, wherein the target object type is created based on the source object type;

retrieving source metadata tables associated with the source object type from the source enterprise content management system, the source metadata tables containing data for objects of the source object type;

storing the source metadata tables as target metadata tables in the target enterprise content management system after storing the target object type in the target enterprise content management system, the target metadata tables containing data for objects of the target object type; and

responsive to storing the source metadata tables as target metadata tables, updating an index of the target enterprise content management system.

18. The computer program product of claim 17, wherein retrieving the source metadata tables comprises executing a third remote procedure call to the source database management system, and wherein storing the source metadata tables as the target metadata tables comprises executing a fourth remote procedure call to the target database management system.

19. The computer program product of claim 17, wherein the computer-readable program code is executable to create the target enterprise content management system.

20. The computer program product of claim 17, wherein the method further comprises:

retrieving an audit trail from the source enterprise content management system; and

storing the audit trail in the target enterprise content management system.

21. The computer program product of claim 17, wherein the method further comprises:

retrieving source content associated with the source enterprise content management system; and

storing the source content as target content associated with the target enterprise content management system.

22. The computer program product of claim 17, wherein the method further comprises upgrading the target enterprise content management system to a next generation enterprise content management system.