Helpful Sql Scripts for Ektron CMS 400.Net

Last Updated September 11, 2011 

A compilation of various SQL scripts I have acquired, modified or written myself to perform various tasks not possible through the workarea (at least as of 8.0).

Disclaimer: if you are downloading and utilizing these scripts, one can only assume you are familiar with SQL Server and: 1) have backed up your database, 2) have tested on a dev or staging instance, 3) run uncommitted until you are certain the appropriate results have been verified. I have spoken. 

• Ektron Find Replace In Content Html—Script to search and replace specific content/phrases through the entire content table. This script can be modified to handle different scenarios as well.
• Ektron Find Replace In Library—Script to search and replace specific library links.
• Ektron Find Replace In SiteMap— Script to search and replace sitemap links/titles/etc.
• Ektron Find Replace In Menu—Script to rename menu link paths. 
• Ektron Find Replace In UrlAliasManual—Script to rename manual aliases. 
• Ektron Find Replace Library Folder Names—Script to rename folder paths of renamed cms folders. 
• Ektron Rename Templates—Script to rename template paths. 
• Ektron Retrieve Current Version Script—

  select convert(varchar,version) from settings