SharePoint Online Vs SharePoint 2010 Server

We are still aware that a migration to Microsoft Office 365 is not definite, we have been hired to research the best migration options for the university. However, it appears that we have not touched on SharePoint 2010 at all in the last few months so we thought we might write a little about it today.

Today we have started to compare Microsoft SharePoint On Premises with SharePoint Online to see which has the most features. I will post the features that one system has but the other might lack, in a table here.

Feature SharePoint 2010 Enterprise SharePoint Online
SharePoint Time Jobs YES NO
Business Data Connectivity Service YES NO
External Data Column YES NO
Business Data Web Parts YES NO
External Lists YES NO
Business Data Integration with Office Client YES NO
Business Connectivity Services Profile Page YES NO
Records Center YES NO
Word Automation Services YES NO
Business Intelligence Center YES NO
Chart Web Parts YES NO
Data Connection Library YES NO
Microsoft Office PerformancePoint Services YES NO
Calculated KPIs YES NO
Dashboards YES NO
Decomposition Tree YES NO
Excel Services and PowerPivot for SharePoint YES NO
Many Search features (about 16) YES (FAST) NO
Single Site Collection Search NO YES
Secure Store Service YES NO
Web Analytics YES NO
Lightweight Public Facing Site NO YES
External Sharing NO YES
Office Web Apps NO YES

So there appear to be a fair amount of features SharePoint 2010 is capable of that SharePoint Online isn’t. However, do keep in mind that the list was extremely long and there are many features the the both of them share, this is just a minority really. Many of the features may not even be needed in the University environment, we will be looking into some of these features so we can better measure the difference between the two SharePoint options.


Migrating in the opposite direction

After reading some blog posts we were concerned about some of the questions these bloggers had asked and never got an answer to. One of this questions was “what happens if you want to leave Office 365 for something else?”, this could be problematic as we wouldn’t want to loose all our data if we wanted to migrate back to SharePoint 2010 (When we do upgraded I don’t think we would go back to SharePoint 2003 ever again). After asking the question in the community forum I quickly got an answer. It is possible to migrate back to SharePoint 2010 but only through a migration tool such as MetaVis, Quest or AvePoint.

I’m still not sure why Microsoft are getting people to rely on 3rd party migration tools so much, even they rely on them for migrating their own systems. You would have thought they create their own migration tools, at the very least they could have made some more money from it.