I have been developing a SharePoint 2010 foundation site using SQL Server backend for a client that has about 400 links that point to my local server. This needed to be done for testing. I now plan to move the entire site to the clients server and need to change pieces of these links to their client server name. I can of course use SP to edit each manually, but you know what that will take using SP's interface. I am looking for a way to do a mass substitution, either through SP or via query hitting the SP database tables directly. An example of the original link would be:
and I want to make it:
where the "myserver" is changed to "theirserver" for all links that have been defined.