Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

GP - SQL Server Migration from SQL 2012 to SQL 2014

Posted on by 80

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

Categories:
  • 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 80 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans