GPUG Summit Phoenix

Upgrade Panel Topic Request

  • 1.  Upgrade Panel Topic Request

    TOP CONTRIBUTOR
    Posted 20 days ago
    I'm facilitating an upgrade panel during Summit.  We come prepared to share our stories of doing our own upgrades.

    What would you like to learn?  Any ideas would help us prepare!  Making this the most valuable session we can for folks facing their next upgrade.

    ------------------------------
    Kim Peterson
    218-862-5002
    Kim@DynamicsConnections.com
    #KimPetersonGP
    ------------------------------


  • 2.  RE: Upgrade Panel Topic Request

    GOLD CONTRIBUTOR
    Posted 20 days ago
    Kim,
    I have done a session like this in the past and am happy to help out again let me know.
    Tanya

    ------------------------------
    Tanya Henderson
    Senior Consultant
    S2 Technology
    Park City UT
    ------------------------------



  • 3.  RE: Upgrade Panel Topic Request

    TOP CONTRIBUTOR
    Posted 20 days ago
    Thanks Tanya.  We have our panelists - they are users sharing their experiences!

    So - what questions do folks have?  challenges?

    ------------------------------
    Kim Peterson
    218-862-5002
    Kim@DynamicsConnections.com
    #KimPetersonGP
    ------------------------------



  • 4.  RE: Upgrade Panel Topic Request

    GPUG ALL STAR
    Posted 20 days ago
    Hi Kim

    Just one comment - Use GP Power Tools Database Validation before you upgrade to solve upgrade issues before they occur.

    There was a reason that GP Support did not want this released when it was created as part of the Support Debugging Tool. They did not want all the upgrade support calls to stop!

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------



  • 5.  RE: Upgrade Panel Topic Request

    TOP CONTRIBUTOR
    Posted 20 days ago
    I'm sure that @Darin Vialpando can come up with a good list of topics you can add to the list incase the participants in the room are quite.  ​​

    ------------------------------
    Kristen Hosman
    Dynamics ERP Consultant
    Briware Solutions Inc.
    Pine, CO
    ------------------------------



  • 6.  RE: Upgrade Panel Topic Request

    Posted 13 days ago
    Thanks much -

    Would like to hear how the actual upgrade activity can be accelerated. We have 54 companies and one of companies has around 30 million records in gl30k table (first fiscal year being 1998).

    The utility just stalls at the gl30k table. We are looking to upgrade to GP2018R2. We are on GP2010 SP1.

    So what I ended up doing was to discard data from gl30k after copying the entire contents over to a  new table, let DynUtilites convert this company and then inserted the data back into gl30k post conversion.

    Is there a better way to go about this?

    Best Regards

    ------------------------------
    Ven Sharma
    Sr ERP Analyst
    Long and Foster Companies
    Chantilly VA
    vensharma@yahoo.com
    Dynamics Credentialed Professional
    ------------------------------



  • 7.  RE: Upgrade Panel Topic Request

    SILVER CONTRIBUTOR
    Posted 12 days ago

    Ven,

     

    Before the upgrade, temporarily resize your Temp database to be at least as big as your GL30000 table (that sounds like your largest table).  The upgrade process copies tables to temp, applies any changes to them and then copies them back to the production table.  Depending on how your autogrowth options are set on your temp database, you could spend a very long time incrementally growing the Temp database on disk.

     

    Do a full database backup and then change your Recovery Model from Full to Simple on your production database.  This will turn off logging saving you time during the upgrade.  When the upgrade is complete, flip your recovery model back to full.

     

    If your database server is a Virtual Machine instead of a physical server, see if you have free ram available in your VM environment and consider temporarily allocating it to your database server.  SQL Server will use all of the memory that you throw at it, loading more of your database in memory and saving you physical disk IOs. Again, after the upgrade resize your memory allocation back to its original size.

     

    Rich

     

     

    Rich LaMarche · Senior IT Specialist

    16 South Golden St, Norwich, CT 06360

    Office: 860-823-4170 • Cell: 860-908-9188

    Email: richlamarche@npumail.com

      You Can Rely On Us! Live Support 24/7/365:860-887-2555

    CONFIDENTIALITY NOTICE: This communication, including any accompanying attachments and documents, is intended only for the use of the intended recipient and may contain confidential and/or proprietary information. If you are not the intended recipient, you are hereby notified that any use, disclosure, copying, dissemination, or distribution of any information derived from this communication is strictly prohibited and may constitute a violation of the Federal Electronics Communications Privacy Act. If you have received this communication in error, you must immediately delete and/or destroy this communication after notifying the sender by return email of your receipt of this communication.



    This email was scanned by Bitdefender





  • 8.  RE: Upgrade Panel Topic Request

    Posted 12 days ago
    Rich - That makes ample sense. Elegant solution. I will sure give this a try.

    Thank you!

    Best Regards

    ------------------------------
    Ven Sharma
    Sr ERP Analyst
    Long and Foster Companies
    Chantilly VA
    vensharma@yahoo.com
    Dynamics Credentialed Professional
    ------------------------------



  • 9.  RE: Upgrade Panel Topic Request

    GOLD CONTRIBUTOR
    Posted 13 days ago
    Kim,
    We have had a good on this week with doing a server move and upgrading from GP2010 and they are on Sql 2008.  The issue is they are on SQL Enterprise with encryption!  They are currently hosted and are moving hosting companies and of course that version is not available readily so this is a good topic to discuss how do you go about doing this server move and upgrade.
    Tanya

    ------------------------------
    Tanya Henderson
    Senior Consultant
    S2 Technology
    Park City UT
    ------------------------------



  • 10.  RE: Upgrade Panel Topic Request

    TOP CONTRIBUTOR
    Posted 11 days ago
    I'm adding both of these situations to our slides for us to discuss during the session.  Any other challenges, tips, etc. that we should include?

    ------------------------------
    Kim Peterson
    218-862-5002
    Kim@DynamicsConnections.com
    #KimPetersonGP
    ------------------------------



  • 11.  RE: Upgrade Panel Topic Request

    GPUG ALL STAR
    Posted 11 days ago
    Hi Kim,
    I did recently 2 upgrades where customers were on GP 2010 or 2013, and both involved moving to the latest 2018 build with server & database moves.. In one case, it was even shifting the configuration from an on-premise setup to a hosted environment at a provider's location. The 2nd case was an on-premise move in-house but still using physical servers (old & new), but with the challenge of using a lot of ISV products & heavy customization.
    The challenges were multiple, in the 1st case mostly because the new server was hosted and not part of the existing client domain, and they had no e-mail setup on the new VM, but the client planned sooner or later to switch to Office365, so it was just a matter of accelerating the decision for at least a couple of users. The users are all accessing the GP fat client thru a Terminal server session to run GP (they didn't wanted the web client).
    In the 2nd case it was essentially the heavy customization & list of 3rd party modules that was challenging.. In the end it was decided to get rid of most customized code (mostly VBA) to replace it with GPPT triggers.
    Very interesting cases as both involved also external data integration with SmartConnect tool...
    Let me know if you want to talk more about it.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    ------------------------------