Below is the code to run POST MTS move. All that needs to be done is to amend 'CHANGEME' parts to the details TekGuys should have given you.


The two SQLs can be run together or not, it only changes the branch record, not 1000s of records.


UPDATE Branch SET BraImagePath = REPLACE(BraImagePath,'C:\OFWbackup\Flex','\\\HF-DC-02\FlexData\CHANGEMME');

UPDATE Branch SET BraClogContPath = REPLACE(BraClogContPath,'C:\OFWbackup\Flex','\\\HF-DC-02\FlexData\CHANGEMME');


The two below need to be run separately. These ARE CHANGING 1000s of records.


Update Patientimage SET Patientimage.PatImgFileName = replace(PatImgFilename,'C:\OFWbackup\Flex\PatientImage','\\\HF-DC-02\FlexData\CHANGEMME\PatientImage')

=========================================================================================


Update CLogContent SET CLogContent.ClogContFilePath = replace(ClogContFilePath,'C:\OFWbackup\Flex\CLogContent','\\\HF-DC-02\FlexData\CHANGEMME\CLogContent')


These two don;t need to be ran as you need to make sure that the ClogCache and PatientIamgeCache are empty anyway, if not, then run these two.


Update PatientImageCache SET PatientImageCache.ImgCacheFileName = replace(ImgCacheFileName,'C:\OFWbackup\Flex\PatientImage','\\\HF-DC-02\FlexData\CHANGEMME\PatientImage')

=====================================================


Update CLogContentCache SET CLogContentCache.CLogCacheFilePath = replace(CLogCacheFilePath,'C:\OFWbackup\Flex\CLogContent','\\\HF-DC-02\FlexData\CHANGEMME\CLogContent')