How-To: Create / Restore Companies Backup – NAV 2018
We are familiar with how to backup database from Sql, but there is a great feature in Dynamics NAV that enable to backup the whole companies or specific company, and that can be done by using “Import/Export from a data file” that have a special extension (*.navdata).
By going through the following steps in the table below you can know how to create and restore company backup.
Sn. | Task | Place | Note |
1 | Export Data File (*.navdata) | Dynamics NAV Client | |
2 | Select All Companies OR Specific Company | Dynamics NAV Client | |
3 | Mark :
· Global Data, Application Data & Application. · Global Data & Application Data. · Application Data Only. · Global Data Only. · Application Only.
|
Dynamics NAV Client | Export Global Data Only will get Business Data, Users & User Permissions.
Export Application Data Only will get Business Data without Users.
Export Application only will get All Objects (Similar to FOB). |
4 | Import Data File to another Database (*.navdata) | Dynamics NAV Client | |
5 | Mark:
· Global Data & Application Data · Global Data Only · Application Data Only |
Dynamics NAV Client | Note that Application can’t be imported from the same window, because you can import Application Objects on Empty Database Not User Accessing Database, furthermore it will defines a new database schema that changes the structure of the business data.
|
There is a common error that i face, that you can’t export the data from a different version of Microsoft Dynamics NAV.
So you must import the data into a database that is compatible with the data in the .navdata file. For example, you cannot import a company into a database that has a different database schema, and you cannot import Microsoft Dynamics NAV 2013 data into a Microsoft Dynamics NAV 2018 database.
I think this Feature can benefit in the following scenarios:
- Technical Support: Solving client issues on Life Environment without Going Offline.
- Solution Design: Design different client solutions and demonstrate to the users for acceptance purpose.
- Training Environment: You can export Demonstration Company & import it in other database then you can train users on your own solution.
See you next post.
This was originally posted here.
*This post is locked for comments