Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Problems migrating "Nav 2009 SP1" to Nav 2013 R2

Posted on by Microsoft Employee

Hi, please understand I've not worked on Dynamics Nav lately. However I've been tasked to upgrade Nav 2009 SP1 to Nav 2013 R2. I've gone through the documentation of the upgrade guide but still a bit lost as to what steps to follow. I've also read the chapter on Upgrading from the book Implementing Dynamics Nav 2013. Also the other thing is that there has been only database conversion but no prior upgrade i.e the Nav 2009 SP1 we have now is just Nav 4.0 being converted (Nav 4 DB converted to Nav 5 DB and Nav 5 DB converted to Nav 2009 SP1) and no upgrade have been done. Thus below are the Questions I have:

        1. Is it possible to upgrade this current Nav (2009 SP1) to 2013 R2

        2. On migrating from 2009 SP1 to 2013 R2 what tool is the best suited for this (Upgrade Toolkit vs Merge Tool)

        3. If using the Merge Tool do I need to export all objects {Tables, Reports, XMLports, Codeunits, Menusuites and Pages} for all three DBs {Cronus 2009 SP1, Customer version 2009 SP1 and Cronus 2013 R2}. Then use the merge tool to compare etc

      4. If using the Upgrade Toolkit what should I export as text to use with the Upgrade Toolkit?


As for the data migration below are my assumptions:

        1. Export all customized objects (objects from application upgrade and manual customization) from Nav 2013 R2 Cronus DB

        2. Do all the data conversation and data transfer with Nav 2009 SP1 client with DB copy by using Upgrade700701.1.FO3. Open Upgraded DB in step 2. with Nav 2013 R2, import upgrade objects and complete data upgrade by using Upgrade700701.2.FOB.

      Please let me know if missing any other steps.

      Thanks.

        *This post is locked for comments

        • StefanJonsson Profile Picture
          StefanJonsson 5 on at
          RE: Problems migrating "Nav 2009 SP1" to Nav 2013 R2

          Considering Data Migration:

          You will need to do data upgrade to 2009 before you can upgrade to 2013.

          So you need to locate the Upgrade Toolkit for NAV 2009, does not matter which service pack (I think).

          There you need to go through the data upgrade process from 4.0 to 2009, using Upgrade4002009.1.fob and Upgrade4002009.2.fob.

          In this upgrade, you start by converting the database by opening it in 2009, that you have allready done. Then both upgrade steps are done in 2009.

          When you go from 2009 to 2013, first step is run in 2009, then the databse is converted (opened in 2013), and then the second step is run.

          Object Merging:

          I would think you should compare to Cronus 4.0, NOT Cronus 2009, as it seems you don't have NAV 2009 objects. Otherwise, yes, you compare 3 databases: OldCust, OldBase, NewBase, and the outcome is NewCust.

        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,280 Super User 2024 Season 2

        #2
        Martin Dráb Profile Picture

        Martin Dráb 230,214 Most Valuable Professional

        #3
        nmaenpaa Profile Picture

        nmaenpaa 101,156

        Leaderboard

        Featured topics

        Product updates

        Dynamics 365 release plans