Richard Seroter published useful utility to store/retrieve BizTalk configuration settings in Enterprise SSO database. I added some more functionality to it.
First, I added Export/Import functions allowing to actually save values in the external XML file (Richard's implementation allowed storing only field names, calling for extra work should you delete and restore SSO aplication). I kept file format the same but added values stored as text nodes:
<sso>
<application name="eCommerce.BizTalk.Configuration">
<description>Configuration storage for eCommerce BizTalk applications</description>
<appUserAccount>BizTalk Application Users</appUserAccount>
<appAdminAccount>BizTalk Server Administrators</appAdminAccount>
<contactInfo>http://geekswithblogs.net/paulp</contactInfo>
<field ordinal="0" label="App1.SiteId" masked="no">2</field>
<field ordinal="1" label="App1.UserId" masked="no">8</field>
<field ordinal="2" label="App2.Timeout" masked="no">5000</field>
<flags configStoreApp="yes" allowLocalAccounts="yes" enableApp="yes" />
</application>
</sso>
New usage scenarios:
1. Saving configuration:
1.1 Create application;
1.2 Save to XML;
1.3 Manage application - Retrieve settings;
1.4 Export to XML file created in (1.2).
2. Restoring previously saved configuration:
2.1 Create application;
2.2 Manage application - Import configuration from file created in (1.4) ;
2.3 Save Changes.
Accordingly, menu items Import/Export available when the Manage Application tab is selected only.
The code can be downloaded here.