ObjectHandling/Compile-ObjectsInNavContainer.ps1
|
<#
.Synopsis Compile Objects to Nav Container .Description Create a session to a Nav container and run Compile-NavApplicationObject .Parameter containerName Name of the container in which you want to compile objects .Parameter filter Filter specifying the objects you want to compile (default is Compiled=0) .Parameter sqlCredential Credentials for the SQL admin user if using NavUserPassword authentication. User will be prompted if not provided .Parameter SynchronizeSchemaChanges Specify Force, Yes or No on whether you want to synchronize schema changes to the database .Example Compile-ObjectsToNavContainer -containerName test2 -sqlCredential (get-credential -credential 'sa') .Example Compile-ObjectsToNavContainer -containerName test2 #> function Compile-ObjectsInNavContainer { Param ( [Parameter(Mandatory=$true)] [string] $containerName, [string] $filter = "compiled=0", [PSCredential] $sqlCredential = $null, [ValidateSet('Force','Yes','No')] [string] $SynchronizeSchemaChanges = 'Force' ) AssumeNavContainer -containerOrImageName $containerName -functionName $MyInvocation.MyCommand.Name $sqlCredential = Get-DefaultSqlCredential -containerName $containerName -sqlCredential $sqlCredential -doNotAskForCredential Invoke-ScriptInNavContainer -containerName $containerName -ScriptBlock { Param($filter, [System.Management.Automation.PSCredential]$sqlCredential, $SynchronizeSchemaChanges) $customConfigFile = Join-Path (Get-Item "C:\Program Files\Microsoft Dynamics NAV\*\Service").FullName "CustomSettings.config" [xml]$customConfig = [System.IO.File]::ReadAllText($customConfigFile) $databaseServer = $customConfig.SelectSingleNode("//appSettings/add[@key='DatabaseServer']").Value $databaseInstance = $customConfig.SelectSingleNode("//appSettings/add[@key='DatabaseInstance']").Value $databaseName = $customConfig.SelectSingleNode("//appSettings/add[@key='DatabaseName']").Value $managementServicesPort = $customConfig.SelectSingleNode("//appSettings/add[@key='ManagementServicesPort']").Value if ($databaseInstance) { $databaseServer += "\$databaseInstance" } if ("$filter" -ne "") { Write-Host "Compiling objects with $filter" } else { Write-Host "Compiling all objects" } $enableSymbolLoadingKey = $customConfig.SelectSingleNode("//appSettings/add[@key='EnableSymbolLoadingAtServerStartup']") if ($enableSymbolLoadingKey -ne $null -and $enableSymbolLoadingKey.Value -eq "True") { Write-Host "Generating symbols for objects compiled" # HACK: Parameter insertion... # generatesymbolreference is not supported by Compile-NAVApplicationObject yet # insert an extra parameter for the finsql command by splitting the filter property $filter = '",generatesymbolreference=1,filter="'+$filter } $params = @{} if ($sqlCredential) { $params = @{ 'Username' = $sqlCredential.UserName; 'Password' = ([System.Runtime.InteropServices.Marshal]::PtrToStringAuto([System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($sqlCredential.Password))) } } Compile-NAVApplicationObject @params -Filter $filter ` -DatabaseName $databaseName ` -DatabaseServer $databaseServer ` -Recompile ` -SynchronizeSchemaChanges $SynchronizeSchemaChanges ` -NavServerName localhost ` -NavServerInstance $ServerInstance ` -NavServerManagementPort "$managementServicesPort" } -ArgumentList $filter, $sqlCredential, $SynchronizeSchemaChanges Write-Host -ForegroundColor Green "Objects successfully compiled" } Export-ModuleMember -Function Compile-ObjectsInNavContainer |