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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcku_gVmyKn1Keo4Q3YKlsdu-X9vAjBewkYA1naXGaOT1RjvgId4rAB-ntyk78Pe8jZJ17jOdhJYhHBr1bkU6l6zkRemfO_Xj3hR3QGGkzyiY4gs22OYRgWYfGOf_BJuqQcVzQl0M6v2k/s640/Export+Data.png)
Please select the options, whether to export all companies, only Application objects, etc. and Click OK. Below is the description of the same.
Select the path to store the file.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOlBjHQLNgA605q2RKsT2WnSiqJS4U5gfPDQX-LK36XZ8wcPlW2hMuabaTm2JXegFcZJyGFfA7QGqZ3wTJxIv1bsfyAXwmdJIEW8coHCiHE2snaS34C-m5ar7lSc1FKCRxCl9EIlajA6c/s640/Exportcompleted.png)
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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWHkjLUowcB91zhKSIFK___TC7Hvi7ST1c03w_7cTOhUG5LHh6c130xr4YfuQMWQ6duPY3ugEiUznGdu94_h6cxxIZl1ZYvTpd9EV9O9dsi4RoCQumkR5wF0qb5OtpNILAg4B5tvyd-z0/s640/importnavdata.png)
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
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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcku_gVmyKn1Keo4Q3YKlsdu-X9vAjBewkYA1naXGaOT1RjvgId4rAB-ntyk78Pe8jZJ17jOdhJYhHBr1bkU6l6zkRemfO_Xj3hR3QGGkzyiY4gs22OYRgWYfGOf_BJuqQcVzQl0M6v2k/s640/Export+Data.png)
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 data | Description |
Company | Exports the specified company or companies, or all companies in the database. This includes the company-specific business data but no other data. |
Global data | Exports 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 data | Exports the data that defines the application in the database. This includes the permissions, permission sets, profiles, and style sheets. |
Application | Exports 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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOlBjHQLNgA605q2RKsT2WnSiqJS4U5gfPDQX-LK36XZ8wcPlW2hMuabaTm2JXegFcZJyGFfA7QGqZ3wTJxIv1bsfyAXwmdJIEW8coHCiHE2snaS34C-m5ar7lSc1FKCRxCl9EIlajA6c/s640/Exportcompleted.png)
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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWHkjLUowcB91zhKSIFK___TC7Hvi7ST1c03w_7cTOhUG5LHh6c130xr4YfuQMWQ6duPY3ugEiUznGdu94_h6cxxIZl1ZYvTpd9EV9O9dsi4RoCQumkR5wF0qb5OtpNILAg4B5tvyd-z0/s640/importnavdata.png)
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