Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2010 upgrade times

Posted on by 859

I am interested in hearing from others about upgrade times from GP9 to 2010, or Gp10 to 2010. I realize that there are a number of factors, but this is just for a general idea for planning.

Currently I have 3 seperate upgrades from GP 9 to GP2010 runnng. all on win 2008 and sql 2008. One takes about 35 minutes per company (108 databases), Another takes about 60 minutes per (50 databases), and the other is about 80 minutes per (50 databases).

Most databases are an average of 600 MB. Some are larger at 4 Gb, 10GB, and the ones over 20GB take a little longer, these times I posted are a basic average for the databases that are bewtween 500 MB and 1 GB. 

*This post is locked for comments

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: GP 2010 upgrade times

    There is no way anyone can tell you whether those time are acceptable or not. I have done upgrades of 1 database alone that take more than 6 hours on fast servers, but the database size is nearing half of terabyte, with quad processors. In contrast, I have upgraded 5 databases totaling no more than 600 GB in less than 2 hours on quad 64-bit servers. As you can see, it's anyone's best guess.

    Take a look at my article From the Newsgroups: Upgrading 150+ company databases as it provides some upgrade strategies for large environments.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP 2010 upgrade times

    You are right, there is no way really of telling whether this time is reasonable for your enviornment, there are so many factors. However, I wouldn't say that the times are excessive. Its a pain if you have 108 companies to do and its taking 30 minutes per....but 30 minutes for a reasonably sized compay isn't too bad.

    You could always run the upgrades on different machines?  Set up a test enviornment and split you companies across the live and test - this will halve the time as they will be running concurrently...but then you have to re-attache the databases in the live. Might be an idea for your test upgrade. When the test runs fine, you can kick things off in the live and know its not going to stop halfway through...and you can go home at night!!!. If you hve a spare clean machine, you could try upgrading on it and see if the performance improoves.

     

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

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

Featured topics

Product updates

Dynamics 365 release plans