Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Moving and upgrading...

Posted on by 10

I have a server running GP 16 with 3 companies.

I have a new server that has 18.3. installed. 

Where do I find the documentation to update and set up those companies on the new server?

Is this really a difficult and time consuming situation?

Categories:
  • Suggested answer
    RE: Moving and upgrading...

    >I'd first recommend looking at the following article:

    KB 878449 - How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server

    support.microsoft.com/.../how-to-transfer-an-existing-microsoft-dynamics-gp-microsoft-small-busi

    **NOTE: The CaptureLogins script in step #1 of KB 878449 hasn’t been updated to work with newer releases of SQL Server, so, as you mentioned you're on SQL Server 2019 currently, you'll need to use this article to migrate the login information for GP users over to the new SQL Server:

      KB 918992 - How to transfer logins and passwords between instances of SQL Server

            support.microsoft.com/.../how-to-transfer-logins-and-passwords-between-instances-of-sql-server

    The KB 878449 article describes how to transfer an existing Microsoft Dynamics GP installation to a new server that is running Microsoft SQL Server. The article also describes how to maintain the user logins and databases.

    For Dynamics GP Upgrading information, you'll find it here:

    docs.microsoft.com/.../upgrade-checklist

    Thanks

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,917 Most Valuable Professional on at
    RE: Moving and upgrading...

    I recommend using GP Power Tools Database Validation BEFORE, DURING and AFTER the upgrade to...

    1) Check the table structures and cleanup data before upgrading to ensure a smooth upgrade

    2) Re-create and fix all the logins on the new server.

    3) Validate that the upgrade of tables has completed after the upgrade.

    Regards

    David

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Moving and upgrading...

    I would seek the assistance of your reseller. You need to be on GP 16.0.0716 to go directly to 18.4. KB 878449 will provide information on how to move companies.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans