O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing the database

The very first daily task of a system administrator is the database backup. Other database management tasks come right behind it. The NAV administration module does not include database backup scripts - this is a task for the SQL Server. Instead of the database backup, you can export and import data from all database tables in an internal NAV format and import the file into a new database.

How to do it...

In the first recipe, we will see how to backup and restore a database with SQL Server cmdlets, then export and import NAV data via the NAV administrator shell. Besides, the recipe gives a brief overview of the PowerShell Integrated Scripting Environment.

  1. Run the NAV 2016 Administration Shell from the Start menu. Start the shell ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required