CRM Online Vs. CRM On Premise

Below you find a good overview of the functionalities available in CRM Online Vs. CRM On Premise.

Capability	CRM Online	CRM On Premises
Exchange Synchronization	CRM for Outlook, Email Router, or Server Synchronization (if using Exchange Online/O365)	CRM for Outlook, Email Router, or Server Synchronization (both Online and on premise)
SharePoint Integration	Server Side	Server Side
Inside View (Insights)	Included	Additional cost
Social Listening	Included	Additional cost
Workflows/dialogs	200	Unlimited
Custom Entities	300	Unlimited
SSRS Reporting	FetchXML, or T-SQL from a locally replicated reporting server	FetchXML or T-SQL
Power BI Reporting	Yes	No
Office 365 Groups	Yes	No
Immersive Excel Online	Yes	No
Mobile Apps	Yes	Yes with IFD and Office 365
Offline Mobile	Yes	No
CRM for Outlook	Yes	Yes
CRM Outlook App	Yes	No
OneNote Integration	Yes	No
Upgrade/Update process	Office 365 admin approves the upgrade before it is installed, update rollups applied automatically	Upgrades and update rollups installed my your administrator
Direct server access	No	Yes
Phone App	Yes	Yes if environment externally facing via ADFS
Tablet App	Yes	Yes if environment externally facing via ADFS
Storage	Limited to the amount of CRM Online storage purchased	Limited to the amount of storage available on your server
Release cycle	Two releases per year. Spring release functionality exclusive to CRM Online, so new functionality available online first.	Fall release released to both CRM Online and On Premises, includes the functionality released in the Spring release.
Migrating	CRM Online customers can migrate On Premises at any time. SQL database provided to client at scheduled time that can be imported to an On Premises deployment.	CRM On Premises customers can migrate to CRM Online and customization for entities can be imported; however, on premises database cannot be moved to Online data center, so a data migration is required.
Sandbox environments	CRM Online provides non production environments as part of your subscription that can be used for dev/test/UAT. The number of organizations received depends on the number of users.	Non production environments can be installed, depending on local server availability.