Search code examples
jsondatabasereplacedotnetnuke2sxc

DNN database search and replace tool


I have a DNN (9.3.x) website with CKEditor, 2sxc etc installed. Now old URLs need to be changed into new URLs because the domain name changed. Does anyone know a tool for searching & replacing URLs in a database of DNN?

I tried "DNN Search and Replace Tool" by Evotiva, but it goes only through native DNN database-tables, leaving 2sxc and other plugin /modules tables untouched.

Besides that, there are data in JSON-format in database-tables of 2sxc, also containing old URLs.


Solution

  • I'm pretty sure that the Evotiva tool can be configured to search and replace in ANY table in the DNN database.

    "Easy configuration of the search targets (table/column pairs. Just point and click to add/remove items. The 'Available Targets' can be sorted, filtered, and by default all 'textual' columns of 250 characters or more are included as possible targets."

    It's still a text search.


    As a comment, you should be trying to use relative URLs and let DNN handle the domain name part..