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

zohaibu95@hotmail.com

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.

saravanans87

From SQL there is an option available, Database>Tasks>Import Data, Export Data . Try this.

endjinn

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.

saravanans87

From SQL there is an option available, Database>Tasks>Import Data, Export Data . Try this.

Kishorm

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

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

I'd also recommend looking at dbatools powershell addins for easy SQL migration and various other dba tasks

https://dbatools.io/download/