Mass link changes in SharePoint 2010

Posted on 2011-10-25
Last Modified: 2012-05-12
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.

Any suggestions?
Question by:centech-group
    LVL 38

    Expert Comment

    These are hard coded links?  You didn't use a relative (/sites/clientworld) url?

    Accepted Solution

    Yes hardcoded. These links have to start up code another web on another server. To make it worse we are doing it in a framed environment. In any case, it is what it is.

    Author Closing Comment

    no answer to this question

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
    There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now