Replacing existing document link with new document link

Hi experts!

We are in ECC 6.0 with EhP7 and unicode enabled system

We have linked the third party EDMS (Example: ABC) url with SAP functional location. The SAP user can view the linked document from SAP functional location by opening the url. Approximately 500000 links are established to cover all the functional locations. We are using the functionality for more than 3 years.

The management has decided to replace the existing EDMS with another EDMS (Example: DEF). The project team has migrated all the documents from EDMS-ABC to EDMS-DEF. With this the SAP linked url is broken because the url is changed.

We can very well understand from SAP perspective that, all the existing url in SAP functional location has to be replaced with new url for proper functioning.

Considering the volume of data (500000 links) is there a way or a mapping process which can be established from SAP to EDMS-DEF for doing the automatic mapping based on some parameter like document number?. If we do it manually, it will be huge task and the data integrity would be questionable.

I am sure some of you might have come across this kind of project. Kindly share your experience and knowledge to resolve the issue.

Thanks in advance,

Raj