Migrating data from Nav 2.6 to 6.0 SP1 data only

Business Central/NAV Developers Forum
1

Hi,

Please can some one tell me the best way to migrate data I mean data only from Nav 2.6 to 6.0 SP1. Your advice will be highly appreciated.

Thanks in advance.

2

Hi Gbenga,

That’s an old version! [:)]

If you just want the data and no customizations, then you can use the standard upgrade tools. But not directly. And since you don’t want to upgrade your customizations, then you should consider removing any custom fields you have in your system, including if you have change e.g. field lengths or options in options fields.

The upgrade path will be:

  1. Use the upgrade tool for NAV 3.70 to upgrade from Navision 2.60 to NAV 4.0.

  2. Then use the NAV 2009 SP1 upgrade toolkit to upgrade your data from NAV 4.0 to NAV 2009 SP1.

And why not when you’re started go directly to NAV 2013 and do that extra step of using the NAV 2013 upgrade toolkit to upgrade from NAV 2009 to NAV 2013?

3

Thanks Erik,

All customization have been done on 6.0 SP1 by some one else mine is to migrate the data from Nav 2.6 to 6.0 SP1. Just wandering if there is a way I could move the data from Nav 2.6 to 6.0 SP1 without having to go through the line up of upgrade process. Thanks really appreciate your prompt response.

Gbenga.

4

Well you only other option is to use the RapidStart tool and only migrate master data! Then forget about historical transactions. If you want all data including the transactions then it is still going be faster to use the full upgrade path.

If the customizations have already been upgraded, and old fields created in the new version, then you need take this into considerations also. And basically then it means that you should not see migrating data as a separate project from upgrading the customizations. Everything has to be planned and work together.

You need to know exactly which customized fields are to be included and which needs to be removed as part of the process. Also if some of the customized fields for example are in the job module, then you need to know that this module was changed completely when version 5.0 was introduced, so a lot of data was moved to new tables. The standard upgrade tool make sure that the standard fields are moved, but you need to customize the upgrade tool so that your customized fields are also upgraded.

Congratulations! Your project just go a lot more complex! It’s not something you do “over night”, but something you have to carefully plan and test and test and test, before it will finally work. There are consultants and even partners who do nothing but upgrades, as it is really a very difficult task whenever there are customizations into the picture. At least until you have done it 3-4 times or more.

5

Thanks Erik,

I guess I’m in for a long interesting time.

6

Gbenga,

I’m sure you will have fun while doing it. Personally I actually love to do upgrades and data migration, as long as I don’t have to do it every day!

And please remember to “verify” the answer that helped you “solve” your question…

7

Erik,

I am having some issues with the stock after the migration. All the balances customer, vendor,stock etc are okay after the migration, but the stock is not given me the correct balance after running the Adjust cost item entries for the newly migrated database. Then when i ran the inventory valuation report i am having a total different value when multiplying the cost unit with the quantity. the costing method is average. Any advice would be highly appreciated. I am still walking on it.

Thanks

8

i mean working