Microsoft Dynamics GP, Microsoft Dynamics Retail Management Systems, Microsoft SQL Server version compatibilities
I need some assistance determining version compatibilities of our Microsoft Dynamics GP 9.0 with Microsoft Dynamics RMS Version 2.0.2.14 and MS SQL Server 2012? We have a vendor assisting on the RMS POS side but they are not too sure about the GP side of the integration.
Our current version of RMS is 2.0.0123. We would like to upgrade to 2.0.2.14 for RMS Store Operations, POS and Headquarters so we can use new EMV credit card terminals. One of the requirements for the HQ upgrade is an upgrade to SQL version 2012. We need to learn if these upgrades with conflict with our GP version, Microsoft FRx reporting and the integration manager link between GP and RMS.
Current Version of Microsoft Dynamics Retail Management Systems = 2.0.0123
Version after upgrade: 2.0.2.14
Microsoft Dynamics GP Integration Manager 9.00.0029
Microsoft FRx version 6.7.5014
Our Microsoft Dynamics GP Profession version is 9.00.0274
Dexterity 9.00.0068.0
Smartlist 9.00.0258
Database SQL Server
ODBC Driver Manager 03.52.0000
ODBC Driver 09.00.5000
Microsoft SQL Server 2005 – 9.00.2047.00(Intel x86)
Our Great Plains Server is a Windows Server 2003 RS Std Edition Service Pack 2
On that server the MS SQL Server install has the following version info:
Operating System 5.2.3790
Microsoft .NET Framework 2.0.50727.3662
Microsoft MSXML 2.63.04.05.06.0
Microsoft Internet Explorer 8.0.6001.18702
MDAC 2000.086.3959.00(srv03_sp2
SQL Server Management Studio 9.00.5000.0
If we need to upgrade Great Plains to a higher version, please provide SQL version required and if that SQL version will work with the required RMS version.
Any assistance would be greatly appreciated.
FYI: Microsoft has announced the end of support for RMS with extended support ending in 2021 and Microsoft ended support of our version of GP five years ago.
Our current version of RMS is 2.0.0123. We would like to upgrade to 2.0.2.14 for RMS Store Operations, POS and Headquarters so we can use new EMV credit card terminals. One of the requirements for the HQ upgrade is an upgrade to SQL version 2012. We need to learn if these upgrades with conflict with our GP version, Microsoft FRx reporting and the integration manager link between GP and RMS.
Current Version of Microsoft Dynamics Retail Management Systems = 2.0.0123
Version after upgrade: 2.0.2.14
Microsoft Dynamics GP Integration Manager 9.00.0029
Microsoft FRx version 6.7.5014
Our Microsoft Dynamics GP Profession version is 9.00.0274
Dexterity 9.00.0068.0
Smartlist 9.00.0258
Database SQL Server
ODBC Driver Manager 03.52.0000
ODBC Driver 09.00.5000
Microsoft SQL Server 2005 – 9.00.2047.00(Intel x86)
Our Great Plains Server is a Windows Server 2003 RS Std Edition Service Pack 2
On that server the MS SQL Server install has the following version info:
Operating System 5.2.3790
Microsoft .NET Framework 2.0.50727.3662
Microsoft MSXML 2.63.04.05.06.0
Microsoft Internet Explorer 8.0.6001.18702
MDAC 2000.086.3959.00(srv03_sp2
SQL Server Management Studio 9.00.5000.0
If we need to upgrade Great Plains to a higher version, please provide SQL version required and if that SQL version will work with the required RMS version.
Any assistance would be greatly appreciated.
FYI: Microsoft has announced the end of support for RMS with extended support ending in 2021 and Microsoft ended support of our version of GP five years ago.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER