Migrating 2 million contents from Database to UCM.
Hi,
We want to migrate approximately 2 million content items from the Database to UCM system.We are planning to have a POC done using the following approaches:
Approach 1: Using the Checkin_Universal service:Custom Java code will be reading in the files from the existing database system and Using the RIDC API,we will checkin the same in the UCM system-Time consuming process
Approach 2:Bypassing the Checkin API:We have identified the set of tables and indexes getting updated while checking in the content item in UCM,so we want to bypass the API call and directly insert the data in the respective table-High risk of content loss
I have following questions:
1. What is the strategy that the experts out here would suggest and propose for the migration?
2. Has any one tried their hands on bypassing the service call and using the direct DB insert.
Any pointers and help is highly appreciated,Please respond asap as this is bit urgent and critical.