web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / UPGRADE FROM VERSION 9...
Microsoft Dynamics GP (Archived)

UPGRADE FROM VERSION 9 TO VERSION 2013

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

We are moving to 2013 but we have problems with upgrade the server from 2005 to 2008 and then 2012, any advise. we ( I am new here) server running in different versions running odbc to make connections cause the y cant make it work, and now I dont know how to start

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at

    Hi Pat,

    This probably isn't all inclusive but here are some steps I wrote up for moving databases between servers for test upgrades. I think much of it applies to what you are trying to do.

    1. Transfer SQL Logins to the new server from the old.

      1. http://support.microsoft.com/kb/878449

    2. Restore the Dynamics and Company Databases from the backups made in step 1.

      1. http://support.microsoft.com/kb/871973

      2. If changing SQL Versions you will need to change the compatibility version of the restored databases to match the SQL version currently running on the test server.

    3. Verify DYNSA owns the restored databases.

      1. In SSMS on the new server run sp_helpdb to check database ownership.

      2. If the Dynamics Database or Company Database you intend to upgrade is not owned by DYNSA transfer ownership using sp_changedbowner’DYNSA’

    4. Prior to beginning the update process login to GP as sa and make sure the same version number is shown on the test server as is current on the live server.

    5. Other Prep Stuff

      1. Verify that the Dynamics..DU000030 table is empty.

        1. If it isn’t empty truncate it using Delete Dynamics..DU000030

      2. Make sure the databases you plan to upgrade don’t have any previous information from a failed upgrade.

        1. Select * From DYNAMICS..DB_Upgrade where db_status <> 0

      3. Clear the DEXSQL log and make sure logging is enabled prior to launching utilities.

      4. Shrink the log files of both the company and dynamics databases.

        1. In SSMS right click the DB Name, select tasks, shrink, and file. Change the file type to log and take all defaults.

      5. Change the recovery model of the dynamics and company database from Full to Bulk Logged.

        1. In SSMS right click the DB Name, select properties. The recovery model is on the options page.

    6. Install the service pack or new version of GP.

      1. Make sure the service pack is unblocked prior to launching. If possible always right click and run as admin.

      2. If needed restart the server after installation.

    7. Launch GP Utilities as an admin.

      1. Upgrade your Dynamics and Company databases.

    8. Verify that the databases have been upgraded and GP shows the new version number.

    9. Install new versions of 3rd party software if necessary.

    10. Reset User Passwords using the sa account. If the server name changes you will have to reset them even though you captured them in step 1.

     

    Best regards,

    Kirk

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Thank you so much I will try it.

  • Community Member Profile Picture
    Community Member on at

    Hello, The log file is very big 2883.. any suggestions?

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at

    Hello Pat,

    You can normally shrink the log file without any problems. Make sure you have backups before starting.

    Regards,

    Kirk

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans