The Telligent Evolution Platform starting with version 5 has begun to store considerable amounts of the "Theme" configuration in the database.  Its is often necessary to take the theme configuration from one environment and apply it to another, or modify it in a "bulk" way (like when copying the theme layout from one theme name to another).  The easiest way to transfer a theme layout between two environments is simply a database backup.  When a backup however will not work or has undesired side affects, you can use the built in functionality of Telligent Community and Telligent Evolution to export the theme to XML and then re-import;  I have had mixed success with this result, and often find myself needing to tweak the the process in some way (Change a theme name, replace a particular control with another, or automatically import new layouts and widget configurations on a new community)... 

To make the process of transporting a themes widget layout and configuration easier, I have created a custom control panel page (Attached) named "ExportThemeToSql.aspx".  Just drop this page in your /controlpanel/utility folder and navigate to the page directly...  From it you can select the theme to export and "click generate"  the entire theme configuration from the database will then be transformed into simple SQL statements, which can be run against your other communities or turned into a SQL Patch for your installer.  If you are wanting to copy a theme layout to a new theme, you can export the existing theme, and just search and replace the theme name in the SQL script.

There are a couple of limitations with this tool...  First off it is designed only to export the "default" widget configurations, it does not export anything "saved contextually" as I am making the assumption that you are applying the scripts to differing environments and those environments would have different contextual ids.  Secondly, the new Telligent Evolution Platform 5.5 widget fields "SourceContentFragmentTabId" and "SourceConfiguredContentFragmentId" columns are transfered but don't have their corresponding ids smartly updated, additional logic will need to be added to the import to "repair" these ids should they be required for your theme.

This tool version works with Telligent Enterprise 2.5 and Telligent Community 5.5 only.

Dan