Navcontainerhelper: Restore-BcDatabaseFromArtifacts does not seem to work

[Sven-Niehus]

Describe the issue
Restore-BcDatabaseFromArtifacts does not work, because the PowerShell module that is imported in line 82 does not exist nor can it be installed anymore. The SqlServer PowerShell module should be used as stated in this Microsoft document: https://docs.microsoft.com/en-US/sql/powershell/download-sql-server-ps-module?view=sql-server-ver15

Scripts used to create container and cause the issue

Full output of scripts

Screenshots

Additional context

[freddydk]

The reason for this is that New-NavDatabase uses sqlps and the current code uses that.
Furthermore, I use the smoServer, which I can load after importing sqlps.
sqlps comes with SQL Server (not sure if it is part of client sdk)

I might extend the function with check on whether sqlps is there and if not - then do the same without, but that is a future idea.

[freddydk]

As of Preview404 - this should now work.

1800 is the same issue from @kine which came together with a PR for the solution.