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 12 days ago
    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
    ------------------------------
    GPUG Summit - Post


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

    GOLD CONTRIBUTOR
    Posted 12 days ago
    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
    ------------------------------

    GPUG Summit - Post


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

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Thank you for the prompt reply @Kerry Hataley.  ​

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

    GPUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted 11 days ago
    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
    ------------------------------

    GPUG Summit - Post


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