Article

Microsoft Announces Initial Compatibility of Dynamics GP 2010 and SQL Server 2012

by Jason Gumpert
Editor, MSDynamicsWorld.com

Microsoft is contacting customers and partners today with an update on compatibility between Microsoft Dynamics GP  2010 and SQL Server 2013. 

The short story, as clarified by the DynamicsCare blog, is that a hot fix for SQL Server 2012 will enable compatibility with Dynamics GP 2010 right away.  Business Portal 5.1 will require Service Pack 3, coming in the summer. 

Microsoft's Lucas Miller also provided an alert on the Microsoft Dyanmics GP Support Blog that promised more details in the coming weeks from Microsoft on what the new features of SQL Server 2012 will mean for Dynamics GP users. 

Until now most talk about SQL Server 2012 has been limited to the Dynamics AX, including how the ERP solution can take advantage of capabilities like AlwaysOn Availability Groups.  This feature provides the general benefits of high availability and failover, but also has the potential to improve reporting performance by offering a way to offload some data warehousing needs from the primary database.

Use of PowerView report building tool could be an intriguing improvement for GP 2010 customers as well with its ability to drill down into data sets and create "custom tabular BI models".

BI and Reporting Dynamics GP GP 2010 KPIs SQL Server 2012
About Jason Gumpert

As the editor of MSDynamicsWorld.com, Jason oversees all editorial content on the site and at our events, as well as providing site management and strategy. He can be reached at jgumpert@msdynamicsworld.com.

Prior to co-founding MSDynamicsWorld.com, Jason was a Principal Software Consultant at Parametric Technology Corporation (PTC), where he implemented solutions, trained customers, managed software development, and spent some time in the pre-sales engineering organization. He has also held consulting positions at CSC Consulting and Monitor Group.

More about Jason Gumpert