Building our application
PowerShell is, as the name implies, a very powerful tool that not only supports Dynamics NAV, but most Microsoft applications including the SQL Server. This allows us to generate a single script that restores a new SQL Database, applies our Delta file, compiles objects, and runs the test.
Let's go through this process step by step using an example script. In this script, the parameters are hardcoded for readability. It is recommended that you use variables instead.
- Prepare: the first step is to prepare some mandatory variables, such as a reference to the NAV Ide. Next, load the libraries that we need. We need the SQL Server library and both the NAV libraries:
$NavIde = "C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client\finsql.exe" Set-ExecutionPolicy unrestricted import-module "C:...