Open Forum

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
------------------------------

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
jo.deruiter@aislingdynamics.com
9518674366
Alpharetta, GA
aislingdynamics.com
------------------------------

Original Message:
Sent: Feb 18, 2021 02:56 PM
From: Jason Whitaker
Subject: Upgrading GP with new server

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
------------------------------

@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.

Regards

David​

------------------------------
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
------------------------------

Original Message:
Sent: Feb 18, 2021 02:56 PM
From: Jason Whitaker
Subject: Upgrading GP with new server

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
------------------------------