web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP SQL Server upgrade help and questions.

(0) ShareShare
ReportReport
Posted on by 17

Hello GP Folks,

We are currently in GP 2016 R2 version running on SQL Server 2014. We are planning to upgrade SQL Server from 2014 to 2016 and i have below questions related to SQL Server Upgrade.

Q1-- I know i referred this KB Article  before when we changed SQL Server 2008 R2 to 2014 however i have noticed now this article applies to only below GP versions in which GP 2016 R2 is not one of them. Is it just typo ? or 2016 R2 is missing here on purpose ?

Applies to: Dynamics GP 2010,Dynamics GP 2013,Microsoft Dynamics GP 2015,Microsoft Dynamics GP 2015 R2,Dynamics GP 2016,Dynamics GP,Dynamics GP 2018

Q2-- I also remember from KB Article  when we changed SQL Server 2008 R2 to 2014 that we performed DB maintenance on Dynamics and each company db's. Now i don't see that step in KB except it has been referred to only Dynamics GP 2010 (Step 17 and Step 18). Per my knowledge we have to perform Database Maintenance Utility irrespective of GP version , Please confirm ? 

Please guide me if i am referring to wrong KB and also provide me if there is any other documentation or nice articles with Steps to change SQL Server version. Thanks in advance for your help.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Harold Worby Profile Picture
    1,331 on at

    Microsoft SQL Server 2014-Enterprise, Standard or Express are supported from GP2016 so you should be good to go.

    Capture logins on the old server and create them on the new server, restore the databases to the new server.

    Re-point the DSN.

    Performing Database Maintenance is optional.

  • Preetham theGP Profile Picture
    17 on at

    Thanks for your response. I am unable to navigate to Dex_req.SQL (mbs.microsoft.com/.../ in KB Article 878449 and i am getting error. Can any one please guide me where to get DEX_Req.SQL ?.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans