26 September 2016

Exporting and Importing Companies and Other Data .navdata file NAV 2013 R2 , NAV 2016

Hi All,

You can export a company from a Microsoft Dynamics NAV database and import it into another database, and you can export and import other types of data such as global data, application data, and application objects.

The below option in NAV 2013 R2 was part of NAV 2013 R2 CU 8 Release.

1) Exporting data to .navdata file.

 Search for Export to a Data file Page in NAV Windows RTC.



Please select the options, whether to export all companies, only Application objects, etc. and Click OK. Below is the description of the same.


Type of dataDescription
CompanyExports the specified company or companies, or all companies in the database. This includes the company-specific business data but no other data.
Global dataExports data that is common to all companies in the database. This includes the report list, user IDs, and printer selections, but no company-specific business data.
Application dataExports the data that defines the application in the database. This includes the permissions, permission sets, profiles, and style sheets.
ApplicationExports all application objects. Data is not included.This is similar to exporting all objects to an .fob file.

 Select the path to store the file.




2) Now to Import data back from .navdata file.

Please select Import from a data file Page. Select the .navdata file.

Choose the companies and select the other options as applicable and then click OK. If the company name already exist in database then it will not import.




To use Windows PowerShell cmdlets to import and export data. Please refer below MSDN link

https://msdn.microsoft.com/en-us/library/dn789510(v=nav.90).aspx




Thanks & Regards,
Nandesh Gowda

No comments:

Post a Comment