Move transactional data from NAV 2009 R2 Database to NAV 2016 via SQL SERVER.

zohaibu95@hotmail.com
zohaibu95@hotmail.com Member Posts: 223
edited 2016-11-17 in NAV Three Tier
Dear all,
Just wanted to know, if there is any way to move transactional data from NAV 2009R2 to 2016 from sql server (just like we transfer the data b/w two databases)? Assumed that we have same no of columns in 2016 which is in 2009?

Looking forward to hear your responses.
Best Regards
Zohaib Ahmed
Dynamics NAV ERP Technical Consultant.

please like / agree / verify my answer, if it was helpful for you. thanks.

Best Answer

Answers

  • endjinn
    endjinn Member Posts: 11
    No, you must follow the upgrade steps / use the Upgrade Toolkits provided by Microsoft. The structure of the database has changed from 2009 to 2013 and then again from 2013 to 2016.
  • Kishorm
    Kishorm Member Posts: 921
    zohaibu95 wrote: »
    ...Assumed that we have same no of columns in 2016 which is in 2009?
    That is an incorrect assumption. @endjinn is correct in what he says - structure of tables has changed and you need to go through upgrade process.
  • lfranco
    lfranco Member Posts: 6
    Hi,

    According your expertise should adopt to follow the Microsoft upgrade steps (step-by-step) or you can try to use a mixed solution - Microsoft upgrade steps and the following solution vjeko.com/how-i-reduced-data-upgrade-time-by-78-hours/

  • RSA_Tech
    RSA_Tech Member Posts: 65
    I'd also recommend looking at dbatools powershell addins for easy SQL migration and various other dba tasks

    https://dbatools.io/download/

Categories