Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP - SQL Server Migration from SQL 2012 to SQL 2014

(0) ShareShare
ReportReport
Posted on by 82

Hi All,

Currently we are using GP2015 with SQL 2012 and we are planning to upgrade GP2018 R2 it support SQL 2014

Can you please provide the steps to migrate SQL 2012 to SQL 2014 ?

Best Regards,

Frank

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP - SQL Server Migration from SQL 2012 to SQL 2014

    It appears I was wrong. The last set of upgrade instructions were for GP 2010.

    https://docs.microsoft.com/en-us/previous-versions/dynamics-gp/appuser-itpro/hh686196(v=gp.20)

    SQL is a different matter. Make sure you backup all databases and be prepared to have to uninstall and reinstall SQL. The SQL upgrades usually works but then there are times when it does not.

  • FrankJohnson Profile Picture
    FrankJohnson 82 on at
    RE: GP - SQL Server Migration from SQL 2012 to SQL 2014

    Hi Richard,

    Thank you for the reply. Yes we are planning to upgrade SQL 2012 to SQL 2014 in place (same server). Regarding the upgrade instruction you mentioned that it is available in the install media, is the SQL installation media. Could you please share those upgrade steps (snap or screen shot) ? or where can i find those instructions please help ....

    Best Regards,

    Frank

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP - SQL Server Migration from SQL 2012 to SQL 2014

    You did not mention if you were doing an in place upgrade or not. If you are moving to a new server then follow this.

    https://support.microsoft.com/en-us/help/878449/how-to-transfer-an-existing-microsoft-dynamics-gp-microsoft-small-busi

    Otherwise you will need to upgrade SQL first as GP 2018 is not compatible with SQL 2012. You will find upgrade instructions in the install media.

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans