Hi All,
Presently i am doing upgrade form NAV 2013 R2 to NAV 2018 Cu2 and database size was 426GB. Data upgrade process has taking longer than 3 days because still product group update process running for all history items.
Is there any simple way to do the product group update. Or Usually it takes this much time.
Any suggestion would be highly appreciated.
Thank you
Ramesh
--
*This post is locked for comments
Hello Ramesh,
Please share step by step guide of Microsoft Dynamics Navision 2013 to 2018 upgrade,
Scenario:
Old - Server 2008 (SQL 2012, Nav2013)
New - Server 2016 (SQL 2017, Nav2018)
I am trying to take the SQL Backup and restore in the new server but failed. Is there any proper step by step guideline, please share.
It make sense and the reason is data.
Follow these steps -
1. Open Item category table and check any record with Code = '' (Delete that).
2. Run Product Group Table and check for any record with Item Category code = '' (Delete that).
3. Check Product Group table has unique record w.r.t Code field. If two product group code records have same value for Code then rename and keep it unique.
What these are required -
1. During upgrade data from these two tables will get consolidated in one table.
2. Item Category table data is set to Parent Record and Product Group data is set as child record.
3. Each Child Record is set to Parent code to show data to user.
If any data exist with three cases discussed above upgrade logic goes into a endless loop.
Let me know if any questions.
Hi Ahmed,
Thank you for reply. Is any sample queries please share us will help.
Thank You
Ramesh
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...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (