15,419
Hi
Friend of mine asked me to post this question
They are on NAV 2016 and want to upgrade to BC SaaS (newest version) but all guideline he found is for Nav 2016 to BC 14 which BC 14 is not available on SaaS anymore.
What are the step and process to upgrade from NAV 2016 to BC SaaS? What is the best approach here?
Thanks
Yes, according to my experience, it is possible to migrate from NAV2016 to BC21 on-prem directly, and then use Cloud Migration tool. But remember, it takes a lot of time. We spent whole month to make a first migration, because we don't make this action never before. And yes, we've migrated whole history, all Ledger Entries (Item, Vendor, Customer, Job, G/L, Posted documents, whole data), even all Incoming Documents with attachments.
The hardest thing in this case was make a good SQL scripts with the field mapping. First, I've written a Powershell script to generate SQL migration files. Script gets a source (NAV2016) tables and one by one gets their columns. After that it looks for the new table with $ suffix, f.ex. dbo.Cronus$Item in NAV2016 and dbo.Cronus$Item$Base_Application_Guid and dbo.Cronus$Item$Some_Extension_Guid. If it found a destination table(s) it starts to try to map field using names. If the column with the same name wasn't found, there is a comment in generated SQL script, like [MAP ME MANUALLY]
Here is a little screenshoot for the inspiration
Thanks for the detailed answer. It is really interesting that you were able to go from Nav2016 to BC21 direct. I just wonder if through those SQL Script you were able to move entire history (like vendor/customer ledger. G/L history, etc) to the new SQL?
If you did then do you think it is possible to use your method to move the client from Nav2016 to BC21 on-prem direct then use Cloud Migration Tools to move it to cloud?
Thanks
Hello. The mainstream support of the Business Central 14 aka Spring 2019 will end in October 2023. You can download BC14 OnPrem installation files from official MS release documentation.
As a tip, I share my experience in migration from NAV2016 to BC21. We didn't make indirect migration from NAV2016 to BC14 and then from BC14 to BC21. We made a direct migration from NAV2016 to BC21 OnPrem. It was a very difficult task because of data migration. We've to write a lot of SQL scripts to copy data from NAV2016 tables to the BC21 database. But in the end, everything works great and our customer is satisfied.
You can make your migration in two ways:
1. Make a migration from NAV2016 to BC14, then do a technical and application upgrade from BC14 to BC21 OnPrem, and then use a tool for Cloud Migration.
2. Rewrite all your extensions from C/AL to AL, create an empty BC Cloud instance and start the system using the opening balance.
Hi Dallefeld
Thanks for your answer. I mean the method you describe is my understanding as well. But I do not know how to write step here form him.
Like first upgrade to BC 14 On-Prem. Does even MS has BC14 on SaaS?
Then upgrade from BC 14 On-Prem to BC SaaS?
WoW. How your team can upgrade user from 2016 to BC14 then BC21 in one weekend? Do you mean you upgrade to BC14 in that weekend then just a software upgrade after that?
Sorry for too many questions but I tried to find an answer for him without any success.
Thanks
If I'm not mistaken, you will need to upgrade to BC 14 and then upgrade to current version. I just did this for 30+ companies last month.
We typically take users to BC 14 while we upgrade customizations to extensions. They can test in role tailor client but run in BC Cloud. Then when ready to go live we move then from 2016 to BC14 to BC21 all in one weekend.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,277
Super User 2024 Season 2
#2
Martin Dráb
228,126
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
