SharePoint 2007 vs SharePoint 2010

Everything on this page is contained in Microsoft documentation, on the Microsoft website, on MSDN, on Technet, or in the Microsoft webcasts and presentations. As you can imagine it is placed in multiple pages, across multiple documents, and some of it is contained within specific Microsoft presentations. My goal with this page is to just have all of the comparison information in one place.

Note: I have used symbols here instead of images so it’s easier to copy and paste into a document or another location. So they may not look as nice, but you can use things like find and replace, as well as filter the values if you merge the tables.

Legend:

○= Feature Included

●= Improved In Office Sharepoint Server 2010

☻= New In Office Sharepoint Server 2010

Sites

Feature Name / Area	Sharepoint Server 2007	Sharepoint Server 2010
Office Integration	○	●
Line-Of-Business Integration	○	●
Read/Write Capabilities		☻
Enterprise Management Operations	○	●
Management Tools And Reporting	○	●
Web Analytics		☻
Mobile Connectivity	○	●
Full-Fidelity Viewing		☻
Editing To Mobile		☻
Office Interaction	○	●
Read/Write Capabilities	○	☻
Robust User Experience	○	☻
Contextual Ribbon		☻
Microsoft Silverlight		☻
Office Web Applications		☻
Tagging		☻
Audience Targeting		☻

Communities

Feature Name / Area	Sharepoint Server 2007	Sharepoint Server 2010
My Site: People Profile & Personal Site	○	●
Photos And Presence	○	●
Status Updates	○	●
Ask Me About		☻
Note Board		☻
Recent Activities		☻
Organization Browser		☻
Add Colleagues	○	●
Social Bookmarks		☻
Tags		☻
Tag Clouds		☻
Tag Profiles		☻
My Network		☻
Blogs	○	●
Wikis	○	●
Enterprise Wikis		☻
Ratings		☻
Colleague Suggestions	○	●
Keyword Suggestions		☻

Content

Feature Name / Area	Sharepoint Server 2007	Sharepoint Server 2010
Compliance Everywhere		☻
Flexible Records Management		☻
Shared Content Types And Managed Metadata Service		☻
Content Organizer		☻
Rich Media Management		☻
Document Sets		☻
Word Automation Services		☻
Support For Accessibility Standards		☻

Search

Feature Name / Area	Sharepoint Server 2007	Sharepoint Server 2010
People And Expertise Search	○	●
Search From Windows 7 And Windows Mobile	○	●
Common Connector Framework For Indexing And Federation	○	●
Scale And Performance Via Improved Topology Architecture	○	●
Ability To Build Search-Powered Applications	○	●
Refinement Panel And Sorting		☻
Search In Context		☻
Social Behavior Improves Relevance		☻
Thumbnails, Previews, And View In Browser		☻

Insights

Feature Name / Area	Sharepoint Server 2007	Sharepoint Server 2010
KPI Details		☻
Dashboard Designer	○	●
Enhanced Navigation, Including Filtering And Sorting (Top/Bottom 10, Switchable Measures)		☻
Publish More Workbooks		☻
Javascript Object Model		☻
Powershell Scripting		☻
Richer Fidelity With Excel Workbooks		☻
Support For Analytical Services Formatting		☻
Additional Data Sources, Including External Lists And “PowerPivot” Workbooks		☻
Improved Strategy Map Connection And Formatting		☻
Seamless Management Of Dashboard Content	○	●
Integrated Filter Framework		☻
Calculated KPIs		☻
Improved Visualizations		☻
Chart Web Parts		☻
Business Intelligence Center	(Report Center)	☻

Composites

Feature Name / Area	Sharepoint Server 2007	Sharepoint Server 2010
Browser-Based Customizations	○	●
Business Connectivity Services		☻
Sharepoint Designer	○	●
Human Workflows	○	●
Forms Services	○	●
Visio Services		☻
Access Services		☻
Sandboxed Solutions		☻

Microsoft Office 2010 with Different Versions of SharePoint

Feature Name/Area	Description	SharePoint 2010	SharePoint 2007
Coauthor Documents and Presentations	Share ideas with other people simultaneously and see what areas of a document have changed.	With coauthoring, work together in Microsoft Office Word 2010 and Microsoft Office PowerPoint 2010, and see others’ changes tracked in documents hosted in SharePoint 2010.
Simultaneously Edit Spreadsheets and Notebooks	Work together on content using a Web browser	Work together in Microsoft Office Excel 2010 and Microsoft Office OneNote 2010 Web applications simultaneously and see others’ changes in real time.
Highlight Changes in Shared Notebooks	Enable multiple people to add to and change the same shared notebook. Author names appear in near real time as changes are made.	Shared OneNote 2010 notebooks provide a clear trail of what other authors have changed since the last user opened the notebook.
Broadcast Slide Shows in PowerPoint	Share a PowerPoint presentation over the Web for remote or networked viewers.	Audiences do not need to have PowerPoint 2010 installed; they can see the presentation in high fidelity in a Web browser.
Save Documents and Presentations Directly to SharePoint	Automatically discover SharePoint document libraries to make saving content easier and more intuitive.	People can save Office 2010 documents directly to the SharePoint 2010 document library from Office Backstage view.
PowerPivot	PowerPivot for Excel 2010 provides streamlined integration and Web-based analysis in SharePoint. Use data from multiple sources and manipulate large data sets that have up to hundreds of millions of rows.	Publish and share analysis with less effort and enable others to enjoy the same Data Slicers and fast-query capabilities, even when working in Excel Services reports.
Publish and Share Information Through Excel Services	Share analysis and results across the organization by publishing Excel 2010 spreadsheets to the Web or other SharePoint sites (intranet, extranet).	Use Backstage view in Excel 2010 to selectively publish selective parts of a worksheet, hide formulas, and stage data to SharePoint 2010.	Use Backstage view in Excel 2010 to selectively publish parts of a worksheet to SharePoint 2007.
Microsoft Office Access Design for the Web	Microsoft Office Access 2010 applications developed in Design for Web mode can be designed and edited for publishing to SharePoint, so people can share, collect, and report on data.	Use Access 2010 to publish data, forms, logic/macros, and reports with nearly the same look and feel in the browser as in Access 2010 on a PC.
Automate Metadata Capture	Provide better, automated metadata capture in SharePoint to make information more findable, perceptible, discoverable, navigable, manageable, and re-usable.	Use Word 2010 to provide better and more automated metadata capture from Backstage view, including document information either added automatically or typed quickly in AutoComplete fields.	Word 2010 provides automated metadata capture from Backstage view, including document information added automatically.
Use Office Backstage View	Seamlessly connect Office 2010 applications with SharePoint to provide workflow integration, the ability to enter metadata, and social context.	By using Office Backstage view in Office 2010 applications, people can enter metadata, interact with workflows, access authors’ profiles, view recent content the author has created in SharePoint 2010, and more.	By using Office Backstage view in Office 2010 applications, people can enter metadata and interact with workflows
Access SharePoint Templates	Access Office 2010 document templates stored in SharePoint more quickly and easily.	People can access document templates stored in SharePoint 2010 via the New Document wizard in Office 2010 applications.
Apply PowerPoint Themes to SharePoint	Make customization of SharePoint sites more flexible by using themes used in PowerPoint 2010 presentations.	People can apply themes to SharePoint 2010 sites by using the same themes as in PowerPoint 2010.
Use Reusable Workflows	Support workflows to be used multiple times and provide workflow templates for later use in SharePoint.	SharePoint Designer 2010 supports reusable workflows and workflows attached to content types.
Visualize Workflow	Allow a workflow designer to see the steps in a SharePoint workflow in a visual format.	Workflows developed as drawings and exported from Office Visio 2010 can be imported into SharePoint Designer 2010 for modification and deployment.
Use Forms-Based Applications	Forms-based applications connect with back-end data and include workflow, reporting, custom Web pages, and other components.	Integrate InfoPath 2010 forms with back-end data by using external lists in SharePoint 2010, and include custom sandboxed solution code.
Provide the Office Ribbon for InfoPath Forms Web Services	Provide the Fluent Office Ribbon interface for Web-enabled forms so people can easily find, access, and use the features they want when designing Web-enabled forms.	When used with SharePoint 2010, InfoPath Forms Services provides Web-enabled forms with their commands in a Ribbon interface.
View and Edit Documents, Spreadsheets, Presentations, and Notebooks in the Browser	Allow editing, even if applications are not loaded on a PC.	View and make light edits to documents through Office Web applications in a browser. Document formatting and content are maintained when changes are made in the browser and Web applications can be hosted on the premises running in SharePoint.
Mobile Access Enhancements	View and edit documents from a mobile device even when on the go.	View Office 2010 documents from virtually anywhere by using Web applications, without losing fidelity, and make changes with limited editing capabilities.
Work Offline with an Improved Experience in Microsoft Office Access	Edit Office Access 2010 forms, reports, queries, and macros offline and synchronize changes in SharePoint when reconnected to the network.	Data in SharePoint 2010 list is cached in the Access 2010 by default.
Collaborate Offline and Online	Work offline with SharePoint contents and when reconnected to the network, changes are synchronized.	Work offline in SharePoint 2010 document libraries and lists through SharePoint Workspace 2010.
Fill In Forms Offline	SharePoint list forms are synchronized so people can work offline.	SharePoint 2010 list items open in an InfoPath 2010 form that is hosted in SharePoint for edit in display mode.
Extend the Reach of Forms	Fill in InfoPath 2010 forms in a Web browser, while online or offline, and from a mobile device.	The InfoPath 2010 forms solution offers embedded solutions that use InfoPath controls that can be hosted.
Publish Access Databases to the Web	Securely publish database applications to the Web so IT managers can meet data compliance, backup, and audit requirements.	While publishing data, Access 2010 checks for incompatible objects and builds a report of any runtime differences between the client and server.
Use Business Data Applications	Design forms for SharePoint that create, read, update, and delete business data from a back-end system.	Business data applications start with an external list in SharePoint 2010 and use InfoPath Designer 2010 to create custom forms on top of the list.
Offline and Online LOB Integration	Take LOB data offline and synchronize changes automatically when back online.	Synchronize LOB data in both directions between SharePoint Workspace 2010 and enterprise line-of-business systems by bringing LOB data into SharePoint 2010 Sites and then taking it offline via SharePoint Workspace 2010.
Enhance Information Security and Integrity with Digital Signatures	Help ensure the integrity of information contained in forms with the controls necessary to enable single, co-sign, and counter-sign scenarios for the full form or portions of the form.	InfoPath 2010 and SharePoint 2010 support CNG digitally signed content.
Manage Forms More Easily	More easily manage form versions, updates, and upgrades in SharePoint to ensure that team members are working in the correct version of a form.	Automate template version management with SharePoint 2010 and InfoPath 2010 to provide an improved process for checking for template updates.
Use Line of Business data in applications	Provide a SharePoint-based framework for creating Office Business Applications.	Business Connectivity Services (BCS) provides the read/write capability to connect SharePoint 2010 and Microsoft Office client applications to external data sources (such as SQL, Oracle, SAP, CRM, Siebel, Web services, and custom applications).	Use Business Data Catalog within SharePoint to provide read access and surface line of business information in Office client applications
Business Connectivity Services: Use Data as Document Properties	Insert LOB data as document properties to make critical information more findable, perceptible, and re-usable in SharePoint.	Expose BCS data as Word 2010 document properties and insert it into documents.
Package and More Easily Move SharePoint Applications	Move InfoPath applications more easily from site to site and server to server.	Package InfoPath 2010 applications more quickly and easily packaged by using Windows SharePoint Services solutions (.wsp) and SharePoint site template (.stp) file formats.

Architecture Comparison

Web Services/Object Model

Available with SharePoint 2007:

Administration
Alerts
Authentication
Data Retrieval
Permissions
Sites
Search
People and Profiles
Workflow

New with SharePoint 2010:

List REST access with ADO.NET Data Services
Excel Services REST access
Client Object Model
WSRP (v1.1) Consumer Web Part

Editions

v Enterprise Client Access License

v Standard Client Access License

v SharePoint Server 2010 for Internet Sites, Enterprise

v SharePoint Server 2010 for Internet Sites, Standard

v SharePoint Foundation 2010 (Free)

v SharePoint Designer 2010 (Free)

Microsoft has created a fantastic interactive chart here that goes through each edition.

What’s New For Administrators

Available in SharePoint 2010:

IT Pro Productivity

SharePoint Best Practices Analyzer

Backup And Restore Configuration Data

Site Collection Migration

Content Recovery Down To The Site And List Level

Content Restore Of Site Or List

Windows PowerShell™ Snap-Ins And Commands

Managed Accounts

Correlation IDs

Scalable Unified Infrastructure

Shared Service Applications

Hosting And Multi-Tenancy Architecture With Site Subscriptions

Claims-Based Authentication

Profile Synchronization

High Availability Automatic Failover

Content Type Syndication

Sandbox Solutions

List Throttling

Remote Blog Storage

Flexible Deployment

Prerequisite Installer

Visual Upgrade

Configuration Wizards

Scriptable Deployment

On-Premise Or Online

Diagnostics

Unified Logging Service (ULS)

Usage Database

Developer Dashboard

Reliability and Monitoring

SharePoint Maintenance Engine (SPME) Rules

System Center Operations Manager (SCOM) Monitoring

Reporting

Out of the Box Usage Reports

SCOM Reports

I will try and update this page from time to time with more relevant material (if you know of any please comment here).

Hope this helped someone,
Richard Harbridge

{ 6 trackbacks }

MS SharePoint 2010 explained in detail | ITCS Industry Blog: April 9, 2012 at 2:10 pm
Evento: Disponibles los materiales del evento Microsoft SharePoint Solutions Roadshow! - Blog del CIIN: June 7, 2012 at 4:17 am
Sample Fit/Gap Analysis for SharePoint 2010 Migration from SharePoint 2007 « Charlie Slack's Web Site: July 18, 2012 at 10:02 am
My Links – SP2010 « sharepointarchitecture: August 4, 2012 at 7:23 am
Research Links for Permissions | Cameron Stewart: March 14, 2013 at 8:01 am
SharePoint 2010 | Pampa Point: November 20, 2013 at 3:53 pm

{ 26 comments… read them below or add one }

← Previous Comments

1 Eric Landry June 6, 2011 at 2:20 pm

Mr. Harbridge! Thanks very much Richard. I’m working with a team on a SharePoint 2010 upgrade and this such a great summary. Hope you’re well and um, sorry about those Bruins bro.

2 Eric Landry June 6, 2011 at 2:34 pm

Oh, and I hope the W3C dude calms himself down, does some yoga, or maybe vicodin.

3 SPnewcomer June 20, 2011 at 9:27 am

Hey thanks for the writeup. It was great to get all the differences at one shot rather than searching in different documents.

4 NLV June 29, 2011 at 2:27 am

Greatly helpful. Thanks for the excellent post.

5 Maverick July 17, 2011 at 3:52 am

Hi Richard

Excellent Stuff !! I would also like to seek your opinion on whether its possible to synchonize between Sharepoint 2007 and Sharepoint 2010 using a good replication/sync tool. [email redacted]

Thanks for your help

Regards

6 Richard Harbridge January 3, 2012 at 12:27 pm: The short answer is yes. 🙂

The long answer is that it depends on what it is you are trying to synch. 🙂

Reply

7 anthony.hodge@hrm.northgatearinso.com October 3, 2011 at 12:59 pm

In SharePoint Designer 2007, you use to be able to select multiple files to do a find/replace and the option to select “Find in source code” now that option is not available in 2010, nor does the find/replace seem to work when selecting multiple files.

8 Maureen November 10, 2011 at 12:13 pm

Excellent! Thanks so much. This is exactly what I needed to make my business case for going to SP 2010.

9 vijay November 28, 2011 at 5:16 pm

Excellent…
very much helpful.

10 TMullenaux January 6, 2012 at 2:42 pm

Many thanks! You’ve saved many of us a lot of work!

11 subbareddy kola January 25, 2012 at 2:10 pm

This very useful information for admins and sp designers ….thank u very much giving like this information..

12 Raj March 25, 2012 at 5:06 pm

Hi Richard –

This page is very helpful! Please let me know if I can use the information presented on this page for one of my customers’ request on research materials for their potential upgrade from MOSS 2007 to SP 2010.

Thanks!
-Raj

13 Richard Harbridge March 26, 2012 at 1:54 pm: Absolutely!

Reply

14 Val Blatt May 3, 2012 at 9:27 pm

Hi, Richard! Ditto to almost what everyone else has said. Thank you.

15 Claude May 4, 2012 at 5:51 am

I am looking at a project involving the SharePoint workflow functionality, and am trying to assess what benefits version 2010 provide against the existing functionality on 2007. I don’t believe our use of SharePoint is quite right for the task we asking it to do – essentially create workflows from incoming emails (both internal and external) and shifting them around a number of departments and global hubs – and certainly the architects are not keen on this idea.

The business, however, quite like the current solution – although accepting that it is not perfect. My task is to assess whether or not SharePoint can actually handle this – there could be well in excess of 500,000 individual work items per year – or if it is much wiser to leave this to a more specialised solution. I have my thoughts on this, but cannot back them up with any levels of expertise. Is this something you have come across before?

16 Richard Harbridge May 29, 2012 at 10:56 am: I have come across some pretty beefy workflow implementations, and considerably complex large list/content scenarios. I would need more information to make an informed opinion/recommendation on it, but in general I wouldn’t recommend what you are suggesting.

READ THIS CAREFULLY: http://msdn.microsoft.com/en-us/library/dd441390%28v=office.12%29.aspx – While this is 2007 based, it’s still more or less accurate on most counts (if not all). Remember that 2010 uses the same workflow engine.

These are some example concerns:

1. SharePoint throttles the workflow events and by default I think is set for only so many active workflows at a time. – This can be important because you might get a massive number of emails at once. As an example processing insurance claims would result in large volumes after larger accidents – these claims would also need to be responded to within minutes, and by default the timer jobs run every 5 minutes, as well as challenges around priority of workflows… I wouldn’t recommend it for a situation like this for reliability reasons (re: throttling).

2. To function you would need some data store with 500,000 items a year. Assuming this might be a number of libraries or lists this causes it’s own set of scaling challenges, especially if the workflow performs updates or changes to the items (and is not just reading the items) – read operations scale well past 100,000 but the other methods don’t as well. From a planned retention of workflow history and actions we can assume there will be double if not considerably more. That means well over 1 million records for auditing purposes every year. This is pushing complexity and to be honest SharePoint’s interfaces don’t scale well – you would need custom interfaces for all of this.

3. You run into challenges around how many workflows can really be started within a few seconds. Even if you threw hardware at the problem after 6 servers or so it doesn’t really scale as well… So I can’t think of a hardware architecture that would scale reliably (then think of the DR planning as this sounds like a business critical process)… So the costs and scale are concerns on their own.

Honestly for this I would look at a more transaction focused business process management solution, or feel free to send me a message on linked in and we can discuss in greater detail via email. I have a few vendors I might recommend, but would need to know more. 🙂

Reply

17 ahsiao May 28, 2012 at 1:35 pm

Thanks Richard! This list cleared up quite a few things for me, fantastic.

18 Sandeep Nadig June 5, 2012 at 6:13 am

Thanks Richard! Very usefull information

19 peter June 19, 2012 at 7:09 am

Great! helped a lot.

20 Govind December 4, 2012 at 11:16 pm

This is really fantastic writeup.Please include sharepoint 2013 also 🙂

21 Sushant December 24, 2012 at 12:44 pm

Fantastic Comparision you have done your best

22 Karmit Herzog May 17, 2013 at 6:18 am

I’ve gone over this list and the list of features as compared to 2013, and it seems that there are still several necessary features that haven’t been implemented. For example, wiki improvements still don’t make Confluence’s add-on redundant and the mobile support is still on a browser-website basis, which means that Harmon.ie’s SharePoint for mobile (http://harmon.ie/Products/Mobile) apps are still relevant.

23 Eugene Rosenfeld January 13, 2014 at 3:11 pm

Great write-up!

24 Hiranya April 29, 2014 at 6:04 am

Very spectacular Information….Keep rocking Richard

25 Vijay June 11, 2014 at 9:38 am

Hi Richard, Thanks for the wonderful summary. I was accustomed to use the SP2007 ‘Send immediate alert:’ function that I use to notify the other users. Unfortunately, SP2010 removed (or hid it?) it and the options I have are: post a link to the file via an email, or post an self alert of the folder (in which the file is stored). Both the options are not that easy and convenient as the ‘Send immediate alert:’.. do you have any suggestions/methods to bring back the SP2007 feature to SP2010 (presuming that 2010 hid that feature ;-)) Many thanks for your response, have a nice day!

26 Richard Harbridge January 18, 2015 at 9:58 pm: The methods you listed are both effective. Additionally in 2013 there were more features added that improve communication and alerting from following constructs to Delve and the newer experiences.

Reply

Sharing Informal Business Thoughts, Advice, and Experiences

SharePoint 2007 vs SharePoint 2010