Method and system for migrating content between enterprise content management systems
Migrating content between enterprise content management systems is described. A source object identifier is identified for metadata tables for content for a source enterprise content management system, based on a migration job definition. The metadata tables are retrieved from the source enterprise content management system, based on the source object identifier. A target object identifier is identified for a target enterprise content management system, based on the metadata tables and the migration job definition. An object identifier map is created that maps the source object identifier to the target object identifier. The metadata tables are stored to the target enterprise content management system, based on the object identifier map. The content for the source enterprise content management system is retrieved. The content is stored as content for the target enterprise content management system.
1. A system for migrating between content management systems, the system comprising:
a processor; and
a processor-based application that is executable by the processor to:
in response to receiving, for a migration event, a migration event definition specifying content to be migrated, and a definition of users and roles that are to have access to the content after migration:
execute a procedure call to a source database management system associated with a source content management system to identify a source identifier for a plurality of source metadata tables for the content to be migrated;
retrieve the plurality of source metadata tables from the source content management system using the source identifier;
execute a second procedure call to a target database management system associated with a target content management system to identify a target identifier;
store the plurality of source metadata tables for the content to be migrated as a plurality of target metadata tables of the target content management system based on a mapping of the source identifier to the target identifier;
retrieve the content to be migrated from the source content management system;
store the content for the target content management system; and
define users and roles having access to the content after migration based on the definition of users and roles that are to have access to the content after migration.
2. The system of claim 1 , wherein:
the source identifier is a primary key that uniquely identifies the plurality of source metadata tables for the content to be migrated for the source content management system; and
the target 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 to documents in the content 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 content to be migrated.
4. The system of claim 1 , wherein:
retrieving the plurality of source metadata tables from the source 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 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 source content management system is coupled to the target content management system over a network, and wherein the target content management system is hosted on a distributed computing environment.
6. The system of claim 1 , wherein the source content management system is coupled to the target content management system over a network, and the source content management system is hosted on a distributed computing environment.
7. 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.
8. A computer-implemented method for migrating content between content management systems, the method comprising:
in response to receiving, for a migration event, a migration event definition specifying content to be migrated, and a definition of users and roles that are to have access to the content after migration:
executing a procedure call to a source database management system associated with a source content management system to identify a source identifier for a plurality of source metadata tables for the content to be migrated;
retrieving the plurality of source metadata tables from the source content management system using the source identifier;
executing a second procedure call to a target database management system associated with a target content management system to identify a target identifier;
storing the plurality of source metadata tables for the content to be migrated as a plurality of target metadata tables of the target content management system based on a mapping of the source identifier to the target identifier;
retrieving the content to be migrated from the source content management system;
storing the content for the target content management system; and
defining users and roles having access to the content after migration based on the definition of users and roles that are to have access to the content after migration.
9. The method of claim 8 , wherein:
the source identifier is a primary key that uniquely identifies the plurality of source metadata tables for the content to be migrated for the source content management system; and
the target 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 to documents in the content 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 content to be migrated.
11. The method of claim 8 , wherein:
retrieving the plurality of source metadata tables from the source 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 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 , wherein the source content management system is coupled to the target content management system over a network, and wherein the target content management system is hosted on a distributed computing environment.
13. The method of claim 8 , wherein the source content management system is coupled to the target content management system over a network, and the source content management system is hosted on a distributed computing environment.
14. The method of claim 8 , further comprising coupling a migration appliance to the source content management system and target content management system by a network, wherein the migration appliance is configured to migrate the content from the source content management system to the target content management system.
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:
in response to receiving, for a migration event, a migration event definition specifying content to be migrated, and a definition of users and roles that are to have access to the content after migration:
execute a procedure call to a source database management system associated with a source content management system to identify a source identifier for a plurality of source metadata tables for the content to be migrated;
retrieve the plurality of source metadata tables from the source content management system using the source identifier;
execute a second procedure call to a target database management system associated with a target content management system to identify a target identifier;
store the plurality of source metadata tables for the content to be migrated as a plurality of target metadata tables of the target content management system based on a mapping of the source identifier to the target identifier;
retrieve the content to be migrated from the source content management system;
store the content for the target content management system; and
define users and roles having access to the content after migration based on the definition of users and roles that are to have access to the content after migration.
16. The computer program product of claim 15 , wherein:
the source identifier is a primary key that uniquely identifies the plurality of source metadata tables for the content to be migrated for the source content management system; and
the target 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 to documents in the content 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 content to be migrated.
18. The computer program product of claim 15 , wherein:
retrieving the plurality of source metadata tables from the source 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 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 source content management system is coupled to the target content management system over a network, and wherein the target content management system is hosted on a distributed computing environment.
20. The computer program product of claim 15 , wherein the source identifier identifies the plurality of source metadata tables for the content to be migrated.