Comparing SharePoint 2007 and 2010 Content Databases

It’s no secret that you are not supposed to touch SharePoint databases but there certainly are some scenarios which would tempt you to at least read from them; mostly for performance reasons. For example, if you want to do some kind of reporting with data pulled from lists spread over 15K sites, it’s not a terrible sin to read from content database directly. So, if in any shape or form your code is interacting with database directly you have some work to do to make it work in 2010. It shouldn’t be a surprise that SQL boys in Redmond campus have tweaked the SharePoint 2010 databases.

I did a SQL compare of 2007 and 2010 content databases and here’s my findings:

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

Identical Tables (9):

• BuildDependencies
• DiskWarningDate
• EventBatches
• GroupMembership
• HT_Settings
• RoleAssignment
• SiteVersions
• WebMembers
• WelcomeName

New Tables (16):

• AllFileFragments
• AllListsAux
• AllListsPlus
• AllListUniqueFields
• AllLookupRelationships
• AllWebParts
• CustomActions
• Resources
• SharedAccessRequests
• SiteDeletion
• SolutionResourceUsageDaily
• SolutionResourceUsageDailyOrdinal
• SolutionResourceUsageLog
• SolutionResourceUsageWindowed
• Solutions
• WebsPlus

Dropped Tables (4):

• Categories
• Image0x
• WebCat
• WebParts

Rest of the tables, 78 of them, have their schema modified. So, as you can see, pretty much every table has been re-done. Start making your changes to get ready for 2010. Good times.