Publishing changes for a page through SQL

Overview

If you have multiple changes in draft state and you would like to publish the pages in bulk, you will need to accomplish this programmatically through SQL.

 

Prerequisites

 

Solution

To publish changes for a specific page:

  1. Go to the site's DNN Instance.
  2. Open the Persona bar.
  3. Navigate to Settings > Site Settings > SQL Console.
  4. Enter the following query:
    UPDATE TabVersions set IsPublished = 1 where TabID = %TabiID% and version = %version%;
  5. On the script, replace %TabID% with your updated page's TabID.
  6. Click on the Run Script button. The output will be displayed at the bottom of the page.

 

To publish changes for all pages:

  1. Go to site's DNN Instance.
  2. Open the Persona bar.
  3. Navigate to Settings > Site Settings > SQL Console.
  4. Click on Upload File.
  5. Upload the attached query.
  6. Click on the Run Script button. The output will be displayed at the bottom of the page.

 

Testing

Visit the website and verify that the changes are now published.

 

Attachments

Comments

0 comments

Please sign in to leave a comment.