SharePoint Online Vs OnPrem: Feature Comparison

Standing in a side room this morning at SharePoint Saturday DC (#SPSDC) at the Microsoft Chevy Chase office, I was chatting with Susan Lennon (@susanlennon), Neil McNeely (@neilmcneely) and Adam Levithan (@collabadam) about the differences in features between online and on prem, and not sure where to point people when this question pops up. In the early days of SharePoint, the product team used to put together a “Good, Better, Best” document which walked through this comparison, but the platform has become far too large – and changes happen too frequently – to present this data in a single document or PDF. A quick search provides some detail about different aspects of SharePoint, but most sites point back to a TechNet overview of a SharePoint Online (and Office365) service description.

First off, you lose a lot of detail that came with the old format – and many of the links are less than informative (for example, ‘Governance’ hits all the check marks for each version, and yet the link provides absolutely no detail whatsoever as to what each version does to “solve” the governance dilemma. <snark>But apparently SharePoint has governance, so we’re good to go.</snark>

Second, the checklist of features is split between SharePoint Online and SharePoint on prem SKUs, making it difficult to compare even this limited information. So I grabbed the content and threw it into a single table, and add it here for your viewing pleasure:

Developer featuresSharePoint Foundation 2013SharePoint Server 2013 Standard CALSharePoint Server 2013 Enterprise CALSharePoint Online Plan 1SharePoint Online Plan 2
Access ServicesNoNoYesYesYes
App Catalog (SharePoint)YesYesYesYesYes
App Deployment: Autohosted AppsNoNoNoYesYes
App Deployment: Cloud-Hosted AppsYes1YesYesYesYes
App Deployment: SharePoint-Hosted AppsYesYesYesYesYes
App Management ServicesYes1YesYesYesYes
BCS: Alerts for External ListsNoYesYesNoYes
BCS: App Scoped External Content Types (ECTs)NoYesYesNoYes
BCS: Business Data WebpartsNoYesYesNoYes
BCS: External ListYesYesYesNoYes
BCS: OData connectorNoYesYesNoYes
BCS: Profile PagesNoYesYesNoNo
BCS: Rich Client IntegrationNoNoYesNoNo
BCS: Secure Store ServiceYesYesYesNoYes
BCS: Tenant-level external data logNoNoYesNoYes
Browser-based customizationsYesYesYesYesYes
Client Object Model (OM)YesYesYesYesYes
Client-side rendering (CSR)YesYesYesYesYes
Custom Site DefinitionsNoYesYesNoNo
Custom Site ProvisioningNoNoYesNoNo
Developer SiteNoNoNoYesYes
Forms Based ApplicationsNoYesYesYesYes
Full-Trust SolutionsYesYesYesNoNo
InfoPath Forms ServicesNoNoYesNoYes
JavaScript Object ModelYesYesYesYesYes
List and Library APIsYesYesYesYesYes
Remote Event ReceiverYesYesYesYesYes
REST APIYes

YesYesYesYes
Sandboxed SolutionsYesYesYesYesYes
SharePoint Design ManagerNoYesYesYesYes
SharePoint DesignerYesYesYesYesYes
SharePoint StoreYesYesYesYesYes
Workflow 2010 (.NET 3.5)YesYesYesYesYes
Workflow 2010 (out of the box)NoYesYesYesYes
Workflow 2013NoYesYesYesYes
Workload API: ECM APIsNoYesYesYesYes
Workload API: Search APIsYesYesYesYesYes
Workload API: Social APIsNoYesYesYesYes
Active Directory SynchronizationNoYesYesYesYes
Alternate Access Mapping (AAM)YesYesYesNoNo
Analytics PlatformNoYes2YesYesYes
Anti-malware protectionYesYesYesYesYes
Claims-Based Authentication SupportYesYesYesNoNo
Configuration WizardsNoYesYesNoNo
Deferred Site Collection upgradeYesYesYesYesYes
Distributed CacheYesYesYesNoNo
Host Header Site CollectionsYesYesYesNoNo
Improved Permissions ManagementYesYesYesYesYes
Improved Self-Service Site CreationNoYesYesNoNo
Managed AccountsYesYesYesNoNo
Minimal Download Strategy (MDS)YesYesYesYesYes
OAuthNoYesYesYesYes
Patch ManagementYesYesYesNoNo
Quota TemplatesYesYesYesNoNo
Read-Only Database SupportYesYesYesNoNo
Remote BLOB StorageYesYesYesNoNo
Request ManagementYesYesYesNoNo
Request throttlingYesYesYesNoNo
Resource throttlingYesYesYesNoNo
Service Application PlatformYesYesYesYesYes
SharePoint Health AnalyzerYesYesYesNoNo
SharePoint admin centerNoNoNoYesYes
Shredded StorageYesYesYesYesYes
Site Collection Compliance PoliciesNoYesYesYesYes
Site Collection Health ChecksYesYesYesYesYes
State ServiceYesYesYesNoNo
Streamlined Central AdministrationYesYesYesNoNo
System Status NotificationsYesYesYesNoNo
Unattached Content Database RecoveryYesYesYesNoNo
Upgrade evaluation site collectionsYesYesYesYesYes
Usage Reporting and LoggingYesYesYesNoNo
Windows PowerShell SupportYesYesYesYesYes
Accessibility Standards SupportYesYesYesYesYes
Asset Library Enhancements/Video SupportNoYesYesYesYes
AuditingNoYesYesYesYes
Auditing & Reporting (e.g. doc edits, policy edits, deletes)NoYesYesYesYes
Content OrganizerNoYesYesYesYes
Design ManagerYesYesYesYesYes
Document SetsNoYesYesYesYes
Document Translation in Word OnlineYes3Yes3Yes3YesYes
eDiscoveryNoNoYesNoYes
Email enabled lists and librariesYesYesYesNoNo
External Sharing: External AccessNoNoNoYesYes
External Sharing: Guest LinkNoNoNoYesYes
Folder SyncNoYesYesYesYes
IRM using Azure Rights ManagementNoNoNoNo1No1
IRM using Windows Server AD RMSYes5Yes5Yes5NoNo
In-Place HoldNoYesYesNoYes
Managed Metadata ServiceNoYesYesYesYes
Metadata-driven NavigationNoYesYesYesYes
Multi-stage DispositionNoYesYesYesYes
Office ProPlus (Osub)NoNoNoNoNo
Office Online (edit)Yes3Yes3Yes3NoNo
Office Online (view)Yes3Yes3Yes3YesYes
Office Web Apps Server integrationYesYesYesNoNo
PowerPoint Automation ServicesNoYesYesNoNo
Preservation hold libraryNoNoYesNoYes
Quick EditYesYesYesYesYes
Records managementNoYesyesYesYes
Recycle Bin (SharePoint admin center)NoNoNoYesYes
Recycle Bin (site collection)YesYesYesYesYes
Related ItemsYesYesYesYesYes
Rich Media ManagementNoYesYesYesYes
Shared Content TypesNoYesYesYesYes
SharePoint Translation ServicesNoYesYesYesYes
Site mailboxNoYes4Yes4Yes2Yes2
SurveysNoYes3Yes3NoNo
Unique Document IDsNoYesYesYesYes
Video SearchNoNoYesNoYes
WCM: AnalyticsNoYes2YesYesYes
WCM: CatalogNoNoYesNoYes
WCM: Category page and catalog item pageNoNoYesNoYes
WCM: Search web partsNoNoYesNoYes
WCM: Cross-Site PublishingNoNoYesNoYes
WCM: Designer ToolsNoYesYesYesYes
WCM: Faceted navigationNoNoYesNoNo
WCM: Image RenditionsNoNoYesYesYes
WCM: Managed navigationNoYesYesYesYes
WCM: Mobile and Device RenderingNoYesYesYesYes
WCM: Multiple DomainsNoNoYesNoNo
WCM: RecommendationsNoYesYesYesYes
WCM: Search Engine Optimizations (SEO)NoYesYesYesYes
Word Automation ServicesNoYesYesNoNo
Business Intelligence CenterNoNoYesNoYes
Calculated Measures and MembersNoNoYesNoYes
Data Connection LibraryNoNoYesNoYes
Decoupled PivotTables and PivotChartsNoNoYesNoYes
Excel ServicesNoNoYesNoYes
Field list and Field SupportNoNoYesNoYes
Filter EnhancementsNoNoYesNoYes
Filter SearchNoNoYesNoYes
PerformancePoint ServicesNoNoYesNoNo
PerformancePoint Services (PPS) Dashboard MigrationNoNoYesNoNo
Power View for Excel in SharePointNoNoYesNoYes
Power Pivot for Excel in SharePointNoNoYesNoYes
Quick ExploreNoNoYesNoYes
Scorecards & DashboardsNoNoYesNoNo
SQL Server Reporting Services (SSRS) Integrated ModeYesYesYesNoNo
Timeline SlicerNoNoYesNoYes
Visio ServicesNoNoYesNoYes
Advanced Content ProcessingYesYesYesNoNo
Continuous crawlsYesYesYesYesYes
Custom entity extractionNoNoYesNoNo
Deep linksNoYesYesYesYes
Event-based relevancyNoYesYesYesYes
Expertise SearchNoYesYesYesYes
Extensible content processingNoNoYesNoNo
Graphical refinersNoYesYesYesYes
Hybrid searchYesYesYesYesYes
Manage search schemaYesYesYesYesYes
On-premises search indexYesYesYesNoNo
Phonetic name matchingNoYesYesYesYes
Query rules—Add promoted resultsNoYesYesYesYes
Query rules—advanced actionsNoNoYesNoNo
Query spelling correctionYesYesYesYesYes
Query suggestionsNoYesYesYesYes
Query throttlingNoYesYesYesYes
Quick previewYesYesYesYesYes
Ranking modelsYesYesYesYes3Yes3
RecommendationsNoYesYesYesYes
RefinersYesYesYesYesYes
RESTful Query API/Query OMYesYesYesYesYes
Result sourcesYesYesYesYesYes
Search connector frameworkNoYesYesNoNo
Search results sortingYesYesYesYesYes
Search vertical: “Conversations”NoYesYesYesYes
Search vertical: “People”NoYesYesYesYes
Search vertical: “Video”NoNoYesNoYes
“This List” searchesNoYesYesYesYes
Change the lookYesYesYesYesYes
Connections to Microsoft Office ClientsYesYesYesYesYes
Cross Browser SupportYesYesYesYesYes
Custom Managed PathsYesYesYesNoNo
GovernanceYesYesYesYesYes
Large List Scalability and ManagementYesYesYesYesYes
Mobile ConnectivityYesYesYesYesYes
Multi-Lingual User InterfaceYesYesYesYesYes
My TasksNoYesYesYesYes
OOTB Web PartsYesYesYesYesYes
Permissions ManagementYesYesYesYesYes
Project functionality for team sitesYesYesYesYesYes
Project site templateYesYesYesYesYes
Project Summary web partYesYesYesYesYes
Project workspaceYesYesYesYesYes
Public Website (SPO)NoNoNoYesYes
SharePoint ListsYesYesYesYesYes
SharePoint RibbonYesYesYesYesYes
Task listYesYesYesYesYes
Team Site: Drag & DropYesYesYesYesYes
Team Site: NotebookYesYesYesYesYes
Team Site: Simplified AccessYesYesYesYesYes
TemplatesYesYesYesYesYes
ThemesYesYesYesYesYes
VariationsNoYesYesYesYes
Usage AnalyticsNoNoYesYesYes
Work Management ServiceNoYesYesYesYes
Ask Me AboutNoYesYesYesYes
BlogsYesYesYesYesYes
Communities Reputation, Badging, and ModerationNoYesYesYesYes
CommunityNoYesYesYesYes
Company FeedNoYesYesYesYes
FollowNoYesYesYesYes
MicrobloggingNoYesYesYesYes
NewsfeedNoYesYesYesYes
One Click SharingNoYesYesYesYes
People, Sites, Document RecommendationsNoYesYesYesYes
Personal SiteNoYesYesYesYes
Photos and PresenceYesYesYesYesYes
ProfileNoYesYesYesYes
RatingsNoYesYesYesYes
Shared with MeNoNoNoYesYes
Site FeedNoYesYesYesYes
OneDrive for BusinessYes6YesYesYesYes
Tag profilesNoYesYesYesYes
Tasks integrated with OutlookNoYesYesYesYes
Trending TagsNoYesYesYesYes
WikisYesYesYesYesYes
Additional StorageNoNoNoYesYes
Azure Provisioned Apps: Access ServicesNoNoNoYesYes
Azur
e Provisioned Apps: Custom Code in Azure LWR
NoNoNoYesYes
Duet OnlineNoNoNoNoNo

 

Most content and articles that discuss the disparity between on prem and online version lacks any real substance IMHO, focusing more on the business differences and justifications rather than the technical nuances. Few attempt to tackle the full breadth of features, but its typical to find bits and pieces of information within targeted topics.

In a CMSWire article from last fall, well-known SharePoint trainer and consultant Brian Alderman (@brianalderman) goes into a bit more detail on some of the main differences between online and on prem, identifying “the ability to use the new cross-site publishing feature and faceted navigation, key Business Intelligence (BI) components like PerformancePoint, Scorecards and Dashboards are not available, and the Content Search Web Part used to dynamically present data on a page based on a search query is not available.”

SharePoint MVP and consultant Jasper Oosterveld (@SharePTjasper) also jumped in with a post outlining the main differences between online and on prem, highlighting Full Trust Solutions, BCS limited, WCM limited, Performance Point Services, Search Control and Index, and Managed Paths.

I’m sure you can dig around on the web and find more examples, but you’ll improve your luck at finding the answers you need by researching specific topics, rather than looking for broad answers.

Hope this is useful to someone out there.

Christian Buckley

Christian is a Microsoft Regional Director and M365 MVP (focused on SharePoint, Teams, and Copilot), and an award-winning product marketer and technology evangelist, based in Dallas, Texas. He is a startup advisor and investor, and an independent consultant providing fractional marketing and channel development services for Microsoft partners. He hosts the #CollabTalk Podcast, #ProjectFailureFiles series, Guardians of M365 Governance (#GoM365gov) series, and the Microsoft 365 Ask-Me-Anything (#M365AMA) series.

4 Responses

  1. Neil McNeely says:

    Maybe it is time for a reboot of this feature list. Changes they do come and changes they do go!

  2. Thanks for sharing this Christian!

  3. Which is why I’d love to see a community effort to put together more accurate information about what works, what doesn’t around each of these line items. Hmmmm…this gives me an idea for how to pull this together.

  4. Michael Bunyan says:

    Thanks CB, very useful. Ultimately it is very hard to discover a difference that would affect a business requirement until one tries to implement it in SP 2013 or SP Online, and that is very frustrating. Digging around the experts on the web indicates to me that the differences are hard to find.
    Mike B