SharePoint 2010 And SharePoint 2007 Content Database

SharePoint 2007 content database can be used by SharePoint 2010 directly without major problems. You can created a site collection in SharePoint 2007, copy its content database to the SharePoint 2010 environment, configure your SharePoint 2010 site collection content database to it, and you are done! Andrew Connell gave detailed instructions on how to do this with WCM sites.

That implies there're no big difference between SharePoint 2010 and SharePoint 2007 in terms of back-end database schema.

I checked briefly and found following tables existing in SharePoint 2007 but not in SharePoint 2010:

1. Categories
2. Image0x
3. WebCat
4. WebParts

More than 10 tables are added to SharePoint 2010 content database:

1. AllfileFragments
2. AllListsAux
3. AllListsPlus
4. AllListsUniqueFields
5. AllLookupRelateionships
6. AllWebParts
7. CustomActions
8. FeatureTracking
9. Resources
10. SharedAccessRequests
11. SolutionResourceUsageDaily
12. SolutionResourceUsageDailyOrdinal
13. SolutionResourceUsageLog
14. SolutionResourceUsageWindowed
15. Solutions
16. WebsPlus