With Intuitive ERP 9.0 there is no way in the interface to update your server attachment links to a new server location.
I ran the following script on a demo database and it changed all the links:
UPDATE MediaItem
Set
MEI_Path = REPLACE(MEI_Path, '\\OLDSERVER\Share', '\\NEWSERVER\Share');
If you have customized reports, then update “Report Layout File Name (.repx)” location. This can be updated in table: ReportDataSourceObject and column: RDSO_LayoutFileName
To analyze the data, please run the below query and update the location accordingly if required:
Select ReportDataSourceObject , * from RDSO_LayoutFileName
Reference:
https://www.sqltutorial.org/sql-string-functions/sql-replace/