Remote Blob Storage (RBS) is a library API set that is designed to move storage of large binary data (BLOBs) from Microsoft SQL Server to external storage solutions.
When developing a provider it's possible to create provider specific configuration keys that administrators can use to change parameters for your provider. These must be defined at setup time in the machine.config registration of the provider otherwise any attempt by the application to create a ConfigItem object and pass it to the RBS client library will fail. This can be specified as follows:
<Provider name="file">
...
<ProviderSpecificConfigKey name="pool_capacity" format="Number"/>
</Provider>
Formats allowed are Number, Name, Boolean, Binary and Duration. When registering the blob store with the RBS instance, the stored procedure mssqlrbs.rbs_sp_add_blob_store is used. This takes an XML configuration object, where specific values for these custom configuration options can be specified.
<
blob_store_config>
<common>
...
</common>
<extended>
<config_item_list>
<config_item key="pool_capacity" value="7" />
</config_item_list>
</extended>
</blob_store_config>
Correct registration of the provider and installation using the administrative stored procedures can be done using the InstallProvider.exe tool (full source and binaries available) from http://www.codeplex.com/sqlrbs.
- mike
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using