Open Forum

Expand all | Collapse all

Dynamics GP 2015 running on SQL 2008 for upgrade to GP2018

  • 1.  Dynamics GP 2015 running on SQL 2008 for upgrade to GP2018

    GOLD CONTRIBUTOR
    Posted Jun 06, 2019 12:39 PM
    Hi Everyone!

    We are going to be upgrading a client that is currently on GP 2013 to GP 2018 and will be moving servers but we need to upgrade them to 2015 before moving.  My issue is that the SQL server is a shared SQL instance with others so doing an in place SQL update is not an option.

    Does GP 2015 work with SQL 2008 r2?

    Any help you can give is great!

    ------------------------------
    Tammy Chavez
    Senior Software Consultant
    LightHouse Business Information Solutions, LLC.
    albuquerque NM
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Dynamics GP 2015 running on SQL 2008 for upgrade to GP2018

    GOLD CONTRIBUTOR
    Posted Jun 06, 2019 12:46 PM
    Unfortunately no...

    Here is the latest matrix I have for my presentations at Summit and Canada...

    Matrix for Sql Serv er vs Dynamics GP

    ------------------------------
    Kerry Hataley
    CEO & President
    Nanook Software, Inc
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Dynamics GP 2015 running on SQL 2008 for upgrade to GP2018

    GOLD CONTRIBUTOR
    Posted Jun 06, 2019 12:59 PM
    Thank you for the prompt reply @Kerry Hataley.  ​

    ------------------------------
    Tammy Chavez
    Senior Software Consultant
    LightHouse Business Information Solutions, LLC.
    albuquerque NM
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Dynamics GP 2015 running on SQL 2008 for upgrade to GP2018

    TOP CONTRIBUTOR
    Posted Jun 07, 2019 09:38 AM
    We just did the same thing - going from 2013 all the way to 2018 at the beginning of the year.  Prior to that we also had to upgrade our SQL Server.  You're going to have to do the same, testing all the applications and tooling you have on your SQL Server.

    One suggestion: Create a new SQL Server instance on another box entirely which copies your production system.  The upgrade that one and test to see the effects.  Test out all your applications - including GP - and verify that everything is still working okay.  Then start over and do it one more time just to be sure.  If you do it twice straight without any issues, you know you've got a solid upgrade path.

    Then I would give things a minimum of three months to make sure you've gotten everything (like those pesky connected Excel workbooks) before you look at upgrading GP.  If there are no major fires associated with your upgrade, you can use that time to test your GP upgrade.

    Good luck and feel free to contact me for more ideas.  (I'm a DBA and our GP admin.)

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role