Export/Import of Company data from one Nav DB to another

(0) Share

Report

Posted on by mbr

5,136

Hello experts,

I am looking into importing a company data from one NAV db to another. Is this possible without writing SQL script? There are a lot of tables so I m thinking this is too much work. We have NAV 2013 R2 version so not sure if it's available yet. I see it's available in NAV 2018. Any feedback/suggestions from you would be highly appreciated.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report

Hi,
Why not you use configuration packages?
For more details you can have a look at: https://docs.microsoft.com/en-us/previous-versions/dynamicsnav-2013/jj128092(v=nav.70)

Let me know if that is helpful. Thanks

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Hi,

Refer this www.valuetechservices.co.in/nav-configuration-packages-to-data-upload

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

You can export Company data by using Export Data page functionality as .navdata file:

nandeshgowda-navblog.blogspot.com/.../exporting-and-importing-companies-and.html

If you have NAV 2018:

docs.microsoft.com/.../exporting-and-importing-companies-and-other-data

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

It depends what you are trying to do exactly, and what exactly data you need to transfer. Also, will this be one-time data transfer or are you building up a periodical data exchange routine?

There are many ways of how to transfer the data.

- As other members mentioned, you can use configuration packages.

- Alternatively, you can setup and consume web services, especially if you would need periodical data update.

- Export to Excel and import to new database is also an option, if you are cutting the database and would like to enter opening balances at certain period into new database.

- There is also an option to upgrade your current version to 2018 version.

- Setup I/C data exchange for limited part of the data, if this would cover your needs

Was this reply helpful? Yes No