Granted Patent B2

US 12,393,561 · App. 18/448,564 · Granted Aug 19, 2025

Inventors: Michael T. Mohen (Millington, MD); Christopher Dyde (Haddonfield, NJ)

Assignee: OPEN TEXT CORPORATION

G06F16/22G06F16/00G06F16/214G06F16/258G06Q10/0631

Abstract

Claims (61)

1. A system comprising:

a source server comprising a source database, the source database comprising a source object type, and a source metadata table associated with the source object type;

a target server comprising a target database; and

a cloning server coupled to the source server and the target server by a network, the cloning server comprising:

a communications interface;

a computer-readable medium; and

a processor coupled to the communications interface and the computer-readable medium, the computer-readable medium storing computer readable program code executable by the processor for:

executing a first call to the source server to directly interact with the source database at a level of the source database to retrieve the source object type from the source database;

executing a second call to the target server to directly interact with the target database at a level of the target database to create a target object type in the target database, wherein the target object type is based on the source object type;

communicating over the network with the source server to retrieve the source metadata table from the source database; and

communicating over the network with the target server to store the source metadata table in the target database as a target metadata table associated with the target object type.

2. The system of claim 1 , wherein the source server comprises a source repository having a repository identification and storing source objects, wherein the computer readable program code is further executable by the processor for:

communicating over the network with the target server to create a target repository with the same repository identification as the source repository; and

communicating over the network with the source server and the target server to clone the source objects to the target repository as target objects with each target object retaining an object identification of the source object from which the target object was cloned.

3. The system of claim 1 , wherein the source object type includes a schema, metadata and a relationship.

4. The system of claim 1 , wherein the source metadata table comprises a source single value table and a source repeat value table and wherein the target metadata table comprises a target single value table and a target repeat value table.

5. The system of claim 1 , wherein the computer readable program code is further executable by the processor for:

executing a first script to execute the first call;

generating a second script based on the source object type, wherein the second script is executable to store the source object type in the target database as the target object type; and

executing the second script to execute the second call.

6. The system of claim 1 , wherein the computer readable program code is further executable by the processor for:

communicating over the network to retrieve a source audit trail from the source server and store the source audit trail as a target audit trail to the target server.

7. The system of claim 1 , wherein the computer readable program code is further executable by the processor for:

communicating over the network to retrieve source content and store the source content as target content.

8. The system of claim 1 , wherein the target server comprises an enterprise content management system, and wherein the computer readable program code is further executable by the processor for:

communicating over the network with the target server to upgrade the enterprise content management system to a next generation.

9. The system of claim 1 , wherein the target server comprises an enterprise content management system, and wherein the computer readable program code is further executable by the processor for:

communicating with the target server over the network to update an index of the target database.

10. The system of claim 1 , wherein the source server comprises a source enterprise content management system, wherein the source enterprise content management system comprises a source enterprise content management system application program interface, wherein the target server comprises a target enterprise content management system, wherein the target enterprise content management system comprises a target enterprise content management system application program interface, wherein the level of the source database is below the source enterprise content management system application program interface, and wherein the level of the target database is below the target enterprise content management system application program interface.

11. A computer-implemented method comprising:

executing, by a cloning server coupled to a source server and a target server by a network, a first call to the source server comprising a source database, to directly interact with the source database at a level of the source database to retrieve a source object type from the source database, wherein the source database comprises the source object type and a source metadata table associated with the source object type;

executing, by the cloning server, a second call to the target server comprising a target database to directly interact with the target database at a level of the target database to create a target object type in the target database, wherein the target object type is based on the source object type;

communicating, by the cloning server, over the network with the source server to retrieve the source metadata table from the source database; and

communicating, by the cloning server, over the network with the target server to store the source metadata table in the target database as a target metadata table associated with the target object type.

12. The computer-implemented method of claim 11 , wherein the source server comprises a source repository having a repository identification and storing source objects, wherein the method further comprises:

communicating, by the cloning server, over the network with the target server to create a target repository with the same repository identification as the source repository; and

communicating, by the cloning server, over the network with the source server and the target server to clone the source objects to the target repository as target objects with each target object retaining an object identification of the source object from which the target object was cloned.

13. The computer-implemented method of claim 11 , wherein the source object type includes a schema, metadata and a relationship.

14. The computer-implemented method of claim 11 , wherein the source metadata table comprises a source single value table and a source repeat value table and wherein the target metadata table comprises a target single value table and a target repeat value table.

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

executing, by the cloning server, a first script to execute the first call;

generating, by the cloning server, a second script based on the source object type, wherein the second script is executable to store the source object type in the target database as the target object type; and

executing the second script to execute the second call.

16. The computer-implemented method of claim 11 , wherein the method further comprises:

communicating, by the cloning server, over the network to retrieve a source audit trail from the source server and store the source audit trail as a target audit trail to the target server.

17. The computer-implemented method of claim 11 , wherein the method further comprises:

communicating, by the cloning server, over the network to retrieve source content and store the source content as target content.

18. The computer-implemented method of claim 11 , wherein the target server comprises an enterprise content management system, and wherein the method further comprises:

communicating, by the cloning server, over the network with the target server to upgrade the enterprise content management system to a next generation.

19. The computer-implemented method of claim 11 , wherein the target server comprises an enterprise content management system, and wherein the method further comprises:

communicating, by the cloning server, with the target server over the network to update an index of the target database.

20. The computer-implemented method of claim 11 , wherein the source server comprises a source enterprise content management system, wherein the source enterprise content management system comprises a source enterprise content management system application program interface, wherein the target server comprises a target enterprise content management system, wherein the target enterprise content management system comprises a target enterprise content management system application program interface, wherein the level of the source database is below the source enterprise content management system application program interface, and wherein the level of the target database is below the target enterprise content management system application program interface.

21. A system comprising:

a cloning server coupled to a source server and a target server by a network, the source server comprising a source database, the source database comprising a source object type, and a source metadata table associated with the source object type, the target server comprising a target database, the cloning server comprising:

a communications interface;

a computer-readable medium; and

a processor coupled to the communications interface and the computer-readable medium, the computer-readable medium storing computer readable program code executable by the processor for:

executing a first call to the source server to directly interact with the source database at a level of the source database to retrieve the source object type from the source database;

executing a second call to the target server to directly interact with the target database at a level of the target database to create a target object type in the target database, wherein the target object type is based on the source object type;

communicating over the network with the source server to retrieve the source metadata table from the source database; and

communicating over the network with the target server to store the source metadata table in the target database as a target metadata table associated with the target object type.

Assignments (2)

Continuity (5)

References Cited (28)