by JerseyBob
3. February 2010 16:46
We kind of always expected that a BLOB-free content database would be quicker to upgrade from SharePoint 2007 to 2010, especially considering there is some "BLOB consolidation" that happens as a result of prepping the content database for SQL RBS compatibility. It's actually pretty easy to see why it's so much faster...the upgrade process is moving BLOB references (< 100 bytes each) around instead of the actual BLOBs. We've run all kinds of tests with different databases, in different enviroments and configurations and the results are kind of shocking. Every scenario we've tested shows that a BLOB-free content database upgrades about 20 times (2000%) faster than one that is BLOBBED-down.
One of the bigger content databases we tested, with a lot of document versions, took just under 9 hours to upgrade with the BLOBs in the content database and just under 20 minutes without (2700% faster). That's significant in several ways. You can seriously consider an in-place upgrade and have the ability to run it several times in a scheduled maintenance window should you run into any issues. It really makes the entire process considerably more forgiving.
The process from a StoragePoint perspective is really pretty simple:
- Implement our 2007 product with WSS 3.0 or MOSS 2007
- Externalize existing BLOBs
- Upgrade SharePoint
- Upgrade StoragePoint (You'll need our 2010 Beta...send an email to info@bluethreadinc.com and ask for it)
- Migrate from EBS to RBS (optional). Existing EBS profiles can run side-by-side with new RBS profiles, so there is no immediate requirement to migrate them.
Request a Free Trial of StoragePoint and try it yourself. Please let us know what your results are.