I'm trying to find some black and white guidance on the relationship of SQL Server 2008, SQL Server 2008 R2, the FILESTREAM RBS provider and the RBS Framework in general.
It seems to me that at the most basic level, the RBS "framework" from a SQL Server perspective consists of a single script file that helps you prepare your database for enabling RBS. Is there some dependency in this script that causes us
to need SQL Server 2008 "R2"? Or is that more of a requirement of the latest FILESTREAM RBS provider? It really seems like the RBS provider reference DLLs are what really matter from an API standpoint and those are going to run on the
other application servers (not SQL Server) anyway.
For example, I was able to take the code from this site, update it such that it properly supported the new dispose methods, and then deploy the provider on a SharePoint 2010 Beta Content Database using SQL Server 2008. It appears that everything is
working perfectly fine. But I keep hearing that SQL Server 2008 "R2" is a requirement? Why is that? Is "R2" only a requirement because of a dependency that the FILESTREAM RBS provider has? It seems that the RBS provider
from this site doesn't require "R2".
Also, I also read on this discussion board that from a licensing perspective SQL 2008 "Enterprise" is required. Is that documented anywhere?
We're big into Remote BLOB storage where I come from and I'm just trying to prepare for the coming SP2010 / RBS wave. Unfortunately, this CodePlex site and the SQL RBS blog are the only sources of information that I can find anywhere on this topic.