Method and system for migrating content between enterprise content management systems

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

a processor; and

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

receive, for a migration job, a migration job definition specifying a set of documents to be migrated, and a definition of users and roles that are to have access to the set of documents after migration;

based on the migration job definition, execute a first remote procedure call to a source database management system associated with a source enterprise content management system to identify a source object identifier for a plurality of source metadata tables for the set of documents to be migrated;

retrieve the plurality of source metadata tables from the source enterprise content management system using the source object identifier;

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;

create an object identifier map that maps the source object identifier to the target object identifier;

store the plurality of source metadata tables for the set of documents to be migrated as a plurality of target metadata tables of the target enterprise content management system based on the object identifier map;

retrieve the set of documents to be migrated from content for the source enterprise content management system; and

store the set of documents as content for the target enterprise content management system.

2. The system of claim 1 , wherein:

the source object identifier is a primary key that uniquely identifies the plurality of source metadata tables for the set of documents to be migrated for the source enterprise content management system; and

the target object identifier is a primary key for the plurality of target metadata tables.

3. The system of claim 1 , wherein the plurality of source metadata tables includes pointers documents in the set of documents to be migrated, a single value table, and a repeat value table, wherein the repeat value table specifies multiple keywords for each document in the set of documents to be migrated.

4. The system of claim 1 , wherein:

retrieving the plurality of source metadata tables from the source enterprise content management system comprises storing the plurality of metadata tables in a NoSQL non-relational database hosted in a staging environment; and

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 hosted in the staging environment.

5. The system of claim 1 , wherein the processor-based application is further configured to:

store the source object identifier in a workload collection, wherein retrieving the plurality of source metadata tables from the source enterprise content management system using the source object identifier includes retrieving the source object identifier from the workload collection.

6. The system of claim 1 , further comprising a migration appliance coupled to the source enterprise content management system and target content management system by a network, wherein the migration appliance comprises the processor and processor-based application.

7. The system of claim 1 , wherein the same source object identifier identifies the plurality of source metadata tables for the set of documents to be migrated.

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

receiving, for a migration job, a migration job definition specifying a set of documents to be migrated, and a definition of users and roles that are to have access to the set of documents after migration;

based on the migration job definition, executing a first remote procedure call to a source database management system associated with a source enterprise content management system to identify a source object identifier for a plurality of source metadata tables for the set of documents to be migrated;

retrieving the plurality of source metadata tables from the source enterprise content management system using the source object identifier;

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;

creating an object identifier map that maps the source object identifier to the target object identifier;

storing the plurality of source metadata tables for the set of documents to be migrated as a plurality of target metadata tables of the target enterprise content management system based on the object identifier map;

retrieving the set of documents to be migrated from content for the source enterprise content management system; and

storing the set of documents as content for the target enterprise content management system.

9. The method of claim 8 , wherein:

the source object identifier is a primary key that uniquely identifies the plurality of source metadata tables for the set of documents to be migrated for the source enterprise content management system; and

the target object identifier is a primary key for the plurality of target metadata tables.

10. The method of claim 8 , wherein the plurality of source metadata tables includes pointers documents in the set of documents to be migrated, a single value table, and a repeat value table, wherein the repeat value table specifies multiple keywords for each document in the set of documents to be migrated.

11. The method of claim 8 , 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

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 hosted in the staging environment.

12. The method of claim 8 , further comprising:

storing the source object identifier in a workload collection, wherein retrieving the plurality of source metadata tables from the source enterprise content management system using the source object identifier includes retrieving the source object identifier from the workload collection.

13. The method of claim 8 , further comprising coupling migration appliance to the source enterprise content management system and target enterprise content management system by a network, wherein the migration appliance is configured to migrate the set of documents from the source enterprise content management system to the target enterprise content management system.

14. The method of claim 8 , wherein the same source object identifier identifies the plurality of source metadata tables for the set of documents to be migrated.

15. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein, the computer-readable program code comprising instructions executable to:

receive, for a migration job, a migration job definition specifying a set of documents to be migrated, and a definition of users and roles that are to have access to the set of documents after migration;

based on the migration job definition, execute a first remote procedure call to a source database management system associated with a source enterprise content management system to identify a source object identifier for a plurality of source metadata tables for the set of documents to be migrated;

retrieve the plurality of source metadata tables from the source enterprise content management system using the source object identifier;

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;

create an object identifier map that maps the source object identifier to the target object identifier;

store the plurality of source metadata tables for the set of documents to be migrated as a plurality of target metadata tables of the target enterprise content management system based on the object identifier map;

retrieve the set of documents to be migrated from content for the source enterprise content management system; and

store the set of documents as content for the target enterprise content management system.

16. The computer program product of claim 15 , wherein:

the source object identifier is a primary key that uniquely identifies the plurality of source metadata tables for the set of documents to be migrated for the source enterprise content management system; and

the target object identifier is a primary key for the plurality of target metadata tables.

17. The computer program product of claim 15 , wherein the plurality of source metadata tables includes pointers documents in the set of documents to be migrated, a single value table, and a repeat value table, wherein the repeat value table specifies multiple keywords for each document in the set of documents to be migrated.

18. The computer program product of claim 15 , 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

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 hosted in the staging environment.

19. The computer program product of claim 15 , wherein the instructions are further executable to:

store the source object identifier in a workload collection, wherein retrieving the plurality of source metadata tables from the source enterprise content management system using the source object identifier includes retrieving the source object identifier from the workload collection.

20. The computer program product of claim 15 , wherein the same source object identifier identifies the plurality of source metadata tables for the set of documents to be migrated.