Skip to content

CHANGES.md

Latest commit

 

History

History
52 lines (43 loc) · 2.51 KB

CHANGES.md

File metadata and controls

52 lines (43 loc) · 2.51 KB

Changes in PSql

This file documents all notable changes.

Most lines should begin with one of these words: Add, Fix, Update, Change, Deprecate, Remove.

3.0.0

  • Change license to MIT.
  • Change target to PowerShell 7.2 / .NET 6.
  • Change how the module loads dependencies. Now, the module loads dependencies into a private context using the recommended technique to prevent errors if other moduels load conflicting dependencies.
  • Change Cmdlet, renaming to PSqlCmdlet.
  • Remove IConsole, replacing it with a simpler ISqlMessageLogger.
  • Update Microsoft.Data.SqlClient to 5.2.2
  • Add -ReplaceVariablesInComments switch to Expand-SqlCmdDirectives.
  • Add retries on transient failures.
  • Fix EncryptionMode.Default requiring certificate validation for local connections.

2.1.0

  • Update Microsoft.Data.SqlClient to 4.1.0
  • Add dependency Prequel, which is PSql's SQLCMD preprocessor moved to its own NuGet package.
  • Add support for a line comment at end of a SQLCMD directive.

2.0.1

  • Fix GetConnectionString error with -AuthenticationMode SqlPassword and SqlClientVersion.Legacy:

    The specified SqlClient version 'Legacy' does not support authentication mode 'SqlPassword'."

  • Fix GetConnectionString with -AuthenticationMode Default choosing mode SqlPassword instead of AadIntegrated when no credential is specified. This resulted in the error:

    A credential is required when connecting to Azure SQL Database using authentication mode 'SqlPassword'.

2.0.0

The 2.0.0 release is a complete rewrite of PSql.

  • Change module type to binary.
  • Change target to PowerShell 7.0+ / .NET Core 3.1.
  • Change ADO.NET implementation to Microsoft.Data.SqlClient.
  • Add numerous SQL context properties and methods.
  • Add support for Azure Active Directory authentication modes.
  • Add automated build and publish via GitHub Actions.