Replacing Strings in Modules Using SQL Scripts


This article provides the SQL script to replace strings in the Modules table.


9.x and later


Access to DNN database


The script provided replaces strings in the module contents. Do note that It might be possible that the content you want is not inside the Modules table but in other tables, like localization.

Note: It is recommended to always take a backup of the database before running SQL queries.

  1. Open Microsoft SQL Server Management Studio and connect to your database.
  2. Click on the New Query button.
  3. Run the query below.
    Note: Do not forget to replace the values of your @FIND and @REPLACE string variables and the PortalID where you want to replace these values, in case you have multiple Portals in the database. Please refer to the article Default Workflow to find your Portal ID.

    DECLARE @PortalID AS INT = Portal-ID-Goes-Here;
    DECLARE @Find AS NVARCHAR(MAX) = 'Old Value';
    DECLARE @Replace AS NVARCHAR(MAX) = 'New Value';
    SET H.Content = REPLACE(CAST(H.Content as NVarchar(MAX)), @Find, @Replace)
    FROM HtmlText H
    INNER JOIN Modules M
    ON H.Moduleid = M.ModuleID
    WHERE H.Content LIKE '%' + @Find + '%'
    AND M.PortalID = @PortalID


After restarting your application, go to the page where the old string was present and check if it has been replaced.



Article is closed for comments.