abbgrade / psdac Goto Github PK

Message:

ValidationMetadataException: The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
ParameterBindingValidationException: Cannot validate argument on parameter 'Path'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
at , D:\a\PsDac\PsDac\test\Install-Package.Tests.ps1:79

If a dacpac cannot be deployed and Install-DacPackage exits with an error, the dacpac cannot be changed, since the file is still locked by powershell

The docs should be published as github-pages

If a model uses the data type like geography, the command Get-DacDataType results in: ModelPropertyClass SqlDataType is not supported on type UserDefinedType.

Some tests fail to validate the path to the dacpac.

see https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dac.model.foreignkeyconstraint.columns?view=sql-dacfx-150

Thanks for this great library! Makes handling DacPacs from Powershell much easier!

I have a feature request.

At this moment the Get-DacColumn only works for tables. However, views also have Columns and I would like to access them as well.

Thanks!

[-] Context Install-DacPackage.Server.DacService.Database.testdb DacPac failed
ValidationMetadataException: The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
ParameterBindingValidationException: Cannot validate argument on parameter 'Path'. The argument is null or empty. Provide an argument that is not null or empty, and
then try the command again.
at , C:\Users\s.kampmann\Repos\PsDac\test\Install-Package.Tests.ps1:58
[-] Context Install-DacPackage.Server.DacService.Database.wwi DacPac failed
ValidationMetadataException: The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
ParameterBindingValidationException: Cannot validate argument on parameter 'Path'. The argument is null or empty. Provide an argument that is not null or empty, and
then try the command again.
at , C:\Users\s.kampmann\Repos\PsDac\test\Install-Package.Tests.ps1:76

The Install-Package should show a progress.

It would be great to support database drift reporting, like a database schema compare between a deployed database and a dacpac.
Use case is testing of migrations.

Microsoft.SqlServer.DacFx switched from System.Data.SqlClient to Microsoft.Data.SqlClient. Therefore this update requires more testing.

Support the PowerShell help system

The used donet framework netcoreapp2.1 is not longer supported. See https://dotnet.microsoft.com/platform/support/policy/dotnet-core

Implement a command to replaces sqlpackage /a:Publish.

Add a command to create a new DacPackage from a existing database.

Import-Module: D:\a\PsDac\PsDac\test\Install-Package.Tests.ps1:6
Line |
6 | … ipt:PsSmo = Import-Module PsSmo -MinimumVersion 0.6.0 -PassThru -Erro …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| The specified module 'PsSmo' with version '0.6.0' was not loaded because no valid module file was
| found in any module directory.