Open Forum

Expand all | Collapse all

Upgrading GP with new server

  • 1.  Upgrading GP with new server

    Posted 13 days ago
    I apologize if this is too basic of a question but I am curious....  We are upgrading to GP 2018 from GP 2016 this weekend and I've installed GP and all the 3rd party applications on the new server.  I did a test upgrade and moved over the Dynamics db and the company db, ran the upgrade in Utilities, and all works well in testing. (Except the import of the reports was horrible this time and had to use Report Writer for a few of them).

    We have fully tested the upgrade and are comfortable going ahead with the live upgrade tomorrow.  When we get everyone out of GP, we usually backup the Dynamics db and Company db in sql, copy it to the new server and do the upgrade.  My question is, do you always need to do both the Dynamics and company db at the same time or would it be a problem to just do the company db this go round and skip the Dynamics db since I did that this week already?  Do both databases always need to be in sync?  I hope this makes sense.  Just curious as I couldn't find this info.  Thanks!

    Jason Whitaker
    Village of Pinehurst
    Pinehurst NC
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Upgrading GP with new server

    Posted 13 days ago
    Both at the same time, without doubt

    Jo deRuiter
    🌟 GPUG AllStar 2019
    💫Granite Award Winner 2018,2019
    Atlanta Chapter Leader
    Credential Council Co-Chair
    Aisling Dynamics Consulting, LLC
    ERP Practice Manager
    Alpharetta, GA

    Academy - Online Interactive Learning from Experts

  • 3.  RE: Upgrading GP with new server

    Posted 12 days ago
    @Jason Whitaker

    Always keep them in sync. There is data stored in the System database that affects the company database. The best example is the Next Note Index values is stored in the SY01500 table in the system database. If this gets out of sync you can give the same index value to more that one record and end up with cross linked notes.

    Don't forget you can use GP Power Tools Database Validation to recreate all the logins and database users at the SQL level and send emails with their new encrypted temporary passwords so they can login and select their new passwords.



    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    Academy - Online Interactive Learning from Experts

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