More in this section
Forums / Developing with Sitefinity / Replace string value in all Sitefinity tables

Replace string value in all Sitefinity tables

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. Svetli
    Svetli avatar
    0 posts
    Registered:
    09 Mar 2016
    09 Sep 2016
    Link to this post

    Hi all, 

    I was wondering, is there custom tool that can find and replace some string value in all Sitefinity tables? I run search procedure and find 10k results in my DB in dozen tables with dozen columns. Collect them and run simple SQL query would cost me 2-3 days I think.

    Has someone come across with this already?

    Regards, Svetlin.

  2. Victor Leontyev
    Victor Leontyev avatar
    65 posts
    Registered:
    01 Jul 2014
    06 Oct 2016 in reply to Svetli
    Link to this post

    Hi Svetlin,

    You can try to check script mentioned in this article: 

    http://vyaskn.tripod.com/sql_server_search_and_replace.htm

    Keep in mind that it is potentially dangerous operation and you know what you want to do

2 posts, 0 answered