Open Forum

Expand all | Collapse all

Is anyone running GP 2018 + on SQL 2012 ?

  • 1.  Is anyone running GP 2018 + on SQL 2012 ?

    Posted 17 days ago
    We are currently running GP 2016 on SQL 2012 and were planning to upgrade both next year.  We have decided that we can't wait for the year end updates this year and would like to go to the latest version while upgrading.  However, we will not be doing the SQL upgrade until next year and Microsoft is showing SQL 2014 or higher for GP 2018 and up.  We are going to be testing GP 2018 and SQL 2012 but would like to hear if anyone has tried this or is doing it.

    ------------------------------
    Rob White
    Sr. Tech Architect
    D'Arrigo Bros. Co. of CA
    Salinas CA
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    TOP CONTRIBUTOR
    Posted 17 days ago
    First of all, I wouldn't do both upgrades at the same time.  Those are both major system upgrades which can have extensive effects on your environment.  Upgrading both just makes it nearly impossible to determine the source if a problem arises.

    Second, set up a test system and try things out.  I never advocate for upgrading without doing it on a test system first.  That gives you a chance to run through the entire process and test the outcomes prior to doing it on your production system.  If you are even tempted to do the upgrades blind, I would strongly advocate against such a course of action.

    Third, you'll get a warning when you try to upgrade with Tools about the db version.  I think you can bypass it but this is another good reason to test.

    Fourth, given GP's solidity, I seriously doubt there is anything in the newer engine which is going to cause you problems, but - again - this is why you test things out first.  When we upgraded to 2014, we found out that a change to the base engine totally destroyed our custom app performance, but left GP alone.

    Last, I think it goes without saying, but it is always a good idea to get full backups before doing any upgrade.  If you are running in a virtual environment, I'd snapshot the entire VM just after you kick everyone out but before you begin the upgrade.  It doesn't hurt to also take separate database backups in addition.  It's worth the 15 minutes or so to have the peace of mind and a plan if something goes wrong.

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

    Conference-GPUG_200x200


  • 3.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    Posted 14 days ago
    Personally I would disagree with not upgrading SQL and GP at the same time. They are very tied together in how they have been tested by Microsoft as well as the different partners that produce the third party products that go with them. If anything there is more chance of an issue occurring because the SQL version is too low in comparison to GP.

    That being said I agree completely with testing it extensively. In recent years SQL and GP are often more than stable enough to be on non supported versions of the other within reason so you do have a reasonable chance you won't run into any issues.

    ------------------------------
    Scott Davis
    Trudell Medical Limited
    London ON
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    GOLD CONTRIBUTOR
    Posted 13 days ago
    Rob,

    Making a bunch of assumptions here...  but, here's a thought... This may be a good opportunity for you to fight for a dedicated SQL environment for your GP environment.  This should make it easier to upgrade them together (as needed) and not have your systems or projects (i.e. upgrades) yoked to others.

    Chris

    ------------------------------
    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    Posted 12 days ago
    Rob,

    I don't think that is possible. The minimum requirement for GP 2018 is SQL 2014 according to Microsoft.

    System Requirements for Microsoft Dynamics GP


    ------------------------------
    Hussain Al Yousef
    Al Dahan Co
    Dammam - An Nabiyah
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    SILVER CONTRIBUTOR
    Posted 12 days ago
    ​It is possible. By that I mean it will allow you to run GP 18.2 on SQL Server 2012 even though the system requirements say otherwise. Often times the system requirements omit older versions of SQL because Microsoft is not going to go back that many versions in their own testing. It does not necessarily mean it will not work with SQL Server 2012.  I have upgraded some of my customers thru multiple hops from GP 2013 R2 and SQL 2012 to GP 2016 R2 and SQL 2012 to GP 18.2 and SQL 2012. You do not get messages saying this SQL version is not compatible with 18.2 and I have not seen any odd behavior. Everything seems to work fine.  The last step I do then is to upgrade SQL to SQL 2017.  So while I would not recommend running GP 2018 R2 or 18.2 with SQL Server 2012 for the long term, I will say it is possible to do in the short term.

    ------------------------------
    Donny Kensmoe
    Consultant
    Wipfli
    Green Bay WI
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    TOP CONTRIBUTOR
    Posted 7 days ago
    My experience in many decades of supporting Great Plains is if GP says an environment is not supported, do not go down that road, it is not supported and it will not work.  Even if your testing is successful you will have problems in production, and you will waste days and days in frustration, and everyone in your company will blame you.  What to do?  Upgrade SQL, then upgrade Great Plains.  That is the only path to take.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Superior Lighting, Inc.
    Sunrise FL
    ------------------------------

    Conference-GPUG_200x200


  • 8.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    Posted 6 days ago
    I haven't deployed GP with an older SQL version, but I have had a couple of occasions where SQL was shared with other applications, and needed to be upgraded before a new GP version was supported on that platform. (We heavily tested and advised before hand)  In those rare cases, we didn't have any operational problems after updating to a technically non-supported SQL version, but we did encounter problems with GP installation scripting (i.e. service packs, year end updates). The case where it was an issue was installing a service pack where the installation code (logically) was something like:

    if (SQLversion > X)
         Upgrade();
    else
         DoNotUpgrade();

    Once the next version of GP was released and supported that SQL version, all of the upgrade scripts then ran normally and we were back to a happy (and supported) place.

    Before doing what you suggest, I would run a test upgrade on a test server using your existing SQL version to make sure you won't have installation issues. If only one version check is written as:

    If (SQLVersion = x or SQLVersion = y or SQLVersion = z), then it's game over.

    I think it's more likely than not that it will run successfully, but you should be prepared for an as yet unreleased service pack or update to fail until SQL is upgraded.


    ------------------------------
    Jeff Woodard
    Chief Technical Officer
    Transportation Financial Services, Inc.
    West Palm Beach FL
    ------------------------------

    Conference-GPUG_200x200


  • 9.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    GPUG ALL STAR
    Posted 6 days ago
    Hi @Rob White

    You do not specify why you are not upgrading SQL as well as GP, nor why you have decided you can't wait for the year end updates.

    Can you elaborate on why you feel you need to upgrade GP ASAP?  GP2016 is absolutely still supported right now.

    To the other points on here:
    1) Do not try to go against microsoft recommendations.  Again, just because you "can" does not mean you should.
          If you have an issue the first thing they will notice is that you did not follow the compatibility and they will refuse to support it in many cases, or will charge you for it.
    2) SQL and GP are routinely upgraded at the same time
    3) Customizations, if you have them are an entirely different story and much testing will be needed.
    4) Do a Test Upgrade First. Always.​​

    ------------------------------

    ------------------------------

    Conference-GPUG_200x200


  • 10.  RE: Is anyone running GP 2018 + on SQL 2012 ?

    Posted 6 days ago

    Thank you for your response Jo. 

    Yes we typically upgrade SQL and GP at the same time and we were planning to do it early next year.  Our HR and Payroll departments have determined that we need the 2019 YE update to get the 2020 W4 changes.  As you stated we could stay on 2016 and upgrade to the 2019 YE update for GP 2016 but that is still an upgrade for us.  We have a great deal of internally developed dex customization and when we upgrade we would prefer going to the latest version.  We have multiple test environments and have every business unit do a couple weeks of testing so upgrades consume a significant amount of resources.   I was trying to see if anyone else was doing it help me get a better feel for the risk.  I was, and still am, feeling like the risk is extremely.  Donny and Jeff have strengthened my thoughts with their ideas in their responses but I still haven't heard of anyone in production on GP 2018 and SQL 2012.   

    We have the SQL 2019 upgrade project started but hardware will not arrive until next year so if we run GP (18.2) on SQL 2012 if won't be for long.

    I have gotten to the point where I have tested GP (18.2) with the 2019  YE update on multiple installs with no issues so far.  Working on testing our customizations now.

    Thank you Jo and everyone else for your input!
    Rob



    ------------------------------
    Rob White
    Sr. Tech Architect
    D'Arrigo Bros. Co. of CA
    Salinas CA
    ------------------------------

    Conference-GPUG_200x200


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