Skip to content

1.1.0

Latest
Compare
Choose a tag to compare
@whsdevops whsdevops released this 10 Sep 19:27
0783c21

Added

Functions specific to Microsoft SQL Server:

  • ConvertTo-YMsSqlIdentifier for converting a string to an identifer, quoted with square brackets.
  • Get-YMsSqlExtendedProperty for getting extended properties.
  • Get-YMsSqlSchema for getting metadata about a schema.
  • Get-YMsSqlTable for getting metadata about a table.
  • Get-YMsSqlTableColumn for getting metadata about a table.
  • Initialize-YMsSqlDatabase for creating a database.
  • Initialize-YMsSqlSchema for creating a schema.
  • Invoke-YMsSqlCommand for running queries and commands.
  • Remove-YMsSqlTable for dropping a table.
  • Set-YMsSqlExtendedProperty for adding/updating extended properties.
  • Test-YMsSqlExtendedProperty for testing if an extended property exists.
  • Test-YMsSqlSchema for testing if a schema exists.
  • Test-YMsSqlTable for testing if a table exists.
  • Test-YMsSqlTableColumn for testing if a table column exists.

Deprecated

  • The Invoke-YSqlServerCommand function. Replaced with Invoke-YMsSqlCommand.