Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Overview
This document lists the Microsoft SQL Server 2014 features supported with Microsoft Dynamics GP 2013 R2 and later versions.
Microsoft SQL Server 2014 Feature Supportability
| New Microsoft SQL Server 2014 Feature | Supportability | Additional Information |
|---|---|---|
| New Design for Cardinality Estimation | Supported | Click HERE for more information regarding Cardinality Estimation in Microsoft SQL Server 2014. |
| Delayed Durability | Supported | Click HERE for more information regarding Delayed Durability in Microsoft SQL Server 2014. |
| Buffer Pool Extension | Supported | Click HERE for more information regarding Buffer Pool Extension in Microsoft SQL Server 2014. |
| New Microsoft SQL Server 2012 Feature | Supportability | Additional Information |
|---|---|---|
| Data Alerts | Supported | Data Alerts require SQL Server Reporting Services to be deployed in SharePoint Mode Click HERE for more information regarding Data Alerts in Microsoft SQL Server 2012. |
| FileTable | NA | No additional features will be added to Microsoft Dynamics GP to take advantage of the FileTable functionality. |
| Distributed Replay | Supported | Click HERE for more information regarding Distributed Replay in Microsoft SQL Server 2012. |
| Columnstore Indexes | NA | No additional features will be added to Microsoft Dynamics GP to take advantage of the Columnstore Indexes functionality. |
| Contained Databases | Supportability under investigation | Microsoft Dynamics GP is dependent on consistent login information across the SQL Server instance, which is not guaranteed when this feature is used. This supportability of this feature is still under investigation. Click HERE for more information regarding Contained Databases in Microsoft SQL Server 2012. |
| Power View | Supported | The Power View features requires SharePoint Enterprise. No Power View reports will be provided out of the box, however, Customers can create their own Power View reports. Click HERE for more information regarding Power View in Microsoft SQL Server 2012. |
| AlwaysOn | Supportability under investigation | The AlwaysOn feature requires the Enterprise Edition of SQL Server 2012. This supportability of this feature is still under investigation. Click HERE for more information regarding AlwaysOn for Microsoft SQL Server 2012. |
| SQL Server Developer Tools | NA | The SQL Server Developer Tools enhancements will provide value to developers building on the SQL Server platform. No changes will be made in Microsoft Dynamics GP. |
| Transparent Data Encryption | Supported | Click HERE for more information regarding TDE in Microsoft SQL Server 2012. |
Additional Information
Refer to the information below for more information on Microsoft SQL Server 2014.