SQL Find and Replace for Intuitive 9.0

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/