postgresql - Dbup(.net 库)和 Powershell for Postgresql

Question

引用这个link我正在尝试通过 Postgresql 数据库的 powershell 脚本运行 dbup。但是，遇到错误-

Powershell 脚本-

$scriptPath = $args['H:\HelloDbUp\Scripts']
[Reflection.Assembly]::LoadFrom("H:\HelloDbUp\packages\dbup-postgresql.4.2.0\lib\net45\dbup-postgresql.dll")
$dbUp = [DbUp.DeployChanges]::To
$dbUp = [PostgresqlServerExtensions]::PostgresqlDatabase($dbUp, "server=serverName;Port=5432;database=DevOps_TestDB;User ID=postgres;Password=77777;Trusted_Connection=Yes;Connection Timeout=120;")
$dbUp = [StandardExtensions]::WithScriptsFromFileSystem($dbUp, $scriptPath)
$dbUp = [PostgresqlServerExtensions]::JournalToSqlTable($dbUp, 'MySchema', 'MyTable')
$dbUp = [StandardExtensions]::LogToConsole($dbUp)
$upgradeResult = $dbUp.Build().PerformUpgrade()

请帮助我摆脱这个错误!

Answer 1

你能试试下面的吗:

Add-Type -Path 'H:\HelloDbUp\packages\dbup-postgresql.4.2.0\lib\net45\dbup-postgresql.dll'

我也遇到同样的错误，在上面添加就解决了。