Method and system for migrating content between enterprise content management systems

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.

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.

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.

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.

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.

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.