We're migrating a site collection to a new farm (SP2010 to SP2010, same version). In the old farm, the site collection resided at the root of the web application (http://oldsitecollection/). As part of a new governance strategy, in the new farm it will be under a managed path (http://newfarm/sites/sitecollection).
Within the site collection is a blog site (./Blog). Within this blog, all the posts reference images using the absolute path "/Blog/Photos/imageexample.jpg". This absolute reference does not play nice in the new farm as instead of referencing "http://newfarm/sites/sitecollection/Blog/Photos/imageexample.jpg" it now references "http://newfarm/Blog/Photos/imageexample.jpg". The images do not appear as expected as the URL to their location is now incorrect.
Is there a way to update all the URL references at once? Maybe a tool or a bulk operation of some sort? We are currently considering either editing each post and image individually or writing a PowerShell/C# application to go through each item and update the URL.