Method and system for cloning enterprise content management systems
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.
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.