SqlServerDsc.psd1
@{ # Script module or binary module file associated with this manifest. RootModule = 'SqlServerDsc.psm1' # Version number of this module. ModuleVersion = '16.2.0' # ID used to uniquely identify this module GUID = '693ee082-ed36-45a7-b490-88b07c86b42f' # Author of this module Author = 'DSC Community' # Company or vendor of this module CompanyName = 'DSC Community' # Copyright statement for this module Copyright = 'Copyright the DSC Community contributors. All rights reserved.' # Description of the functionality provided by this module Description = 'Module with DSC resources for deployment and configuration of Microsoft SQL Server.' # Minimum version of the Windows PowerShell engine required by this module PowerShellVersion = '5.0' # Minimum version of the common language runtime (CLR) required by this module CLRVersion = '4.0' # Functions to export from this module FunctionsToExport = @('Add-SqlDscNode','Add-SqlDscTraceFlag','Complete-SqlDscFailoverCluster','Complete-SqlDscImage','Connect-SqlDscDatabaseEngine','ConvertFrom-SqlDscDatabasePermission','ConvertFrom-SqlDscServerPermission','ConvertTo-SqlDscDatabasePermission','ConvertTo-SqlDscServerPermission','Disable-SqlDscAudit','Enable-SqlDscAudit','Get-SqlDscAudit','Get-SqlDscDatabasePermission','Get-SqlDscManagedComputer','Get-SqlDscManagedComputerService','Get-SqlDscServerPermission','Get-SqlDscStartupParameter','Get-SqlDscTraceFlag','Import-SqlDscPreferredModule','Initialize-SqlDscRebuildDatabase','Install-SqlDscServer','Invoke-SqlDscQuery','New-SqlDscAudit','Remove-SqlDscAudit','Remove-SqlDscNode','Remove-SqlDscTraceFlag','Repair-SqlDscServer','Set-SqlDscAudit','Set-SqlDscDatabasePermission','Set-SqlDscServerPermission','Set-SqlDscStartupParameter','Set-SqlDscTraceFlag','Test-SqlDscIsDatabasePrincipal','Test-SqlDscIsLogin','Uninstall-SqlDscServer') # Cmdlets to export from this module CmdletsToExport = @() # Variables to export from this module VariablesToExport = @() # Aliases to export from this module AliasesToExport = @() DscResourcesToExport = @('SqlAudit','SqlDatabasePermission','SqlPermission','SqlAG','SqlAGDatabase','SqlAgentAlert','SqlAgentFailsafe','SqlAgentOperator','SqlAGListener','SqlAGReplica','SqlAlias','SqlAlwaysOnService','SqlConfiguration','SqlDatabase','SqlDatabaseDefaultLocation','SqlDatabaseMail','SqlDatabaseObjectPermission','SqlDatabaseRole','SqlDatabaseUser','SqlEndpoint','SqlEndpointPermission','SqlLogin','SqlMaxDop','SqlMemory','SqlProtocol','SqlProtocolTcpIp','SqlReplication','SqlRole','SqlRS','SqlRSSetup','SqlScript','SqlScriptQuery','SqlSecureConnection','SqlServiceAccount','SqlSetup','SqlTraceFlag','SqlWaitForAG','SqlWindowsFirewall') RequiredAssemblies = @() # Private data to pass to the module specified in RootModule/ModuleToProcess. This may also contain a PSData hashtable with additional module metadata used by PowerShell. PrivateData = @{ PSData = @{ # Set to a prerelease string value if the release should be a prerelease. Prerelease = 'preview0007' # Tags applied to this module. These help with module discovery in online galleries. Tags = @('DesiredStateConfiguration', 'DSC', 'DSCResourceKit', 'DSCResource') # A URL to the license for this module. LicenseUri = 'https://github.com/dsccommunity/SqlServerDsc/blob/main/LICENSE' # A URL to the main website for this project. ProjectUri = 'https://github.com/dsccommunity/SqlServerDsc' # A URL to an icon representing this module. IconUri = 'https://dsccommunity.org/images/DSC_Logo_300p.png' # ReleaseNotes of this module ReleaseNotes = '## [16.2.0-preview0007] - 2023-04-01 ### Added - SqlServerDsc - New GitHub Actions workflow that run PSScriptAnalyzer for PRs so any issues are shown directly in the PR''s changed files ([issue #1860](https://github.com/dsccommunity/SqlServerDsc/issues/1860)). - Added a separate integration test jobs for SQL Server Reporting Services to be able to test configuring SQL Server Reportings Services using other values that the default values. - Now updates GitHub Actions automatically by allowing dependabot sending in pull requests. - `SqlSecureConnection` - Added new parameter `ServerName` that will be used as the host name when restarting the SQL Server instance. The specified value should be the same name that is used in the certificate ([issue #1888](https://github.com/dsccommunity/SqlServerDsc/issues/1888)). ### Changed - SqlServerDsc - Update `appveyor.yml` to use `dotnet tool install` to install _GitVersion_. - Re-enable integration tests for SqlRSSetup and SqlRS when running against SQL Server 2019 ([issue #1847](https://github.com/dsccommunity/SqlServerDsc/issues/1847)). - The private function `Import-SQLPSModule` was replaced throughout with the public command `Import-SqlDscPreferredModule` ([issue #1848](https://github.com/dsccommunity/SqlServerDsc/issues/1848)). - Removed the regular expression `features?` from the GitVersion configuration. Before, if a fix commit mentioned the word feature but means a SQL Server feature GitVersion would bump minor instead of patch number. - Update pipeline script that is used to resolve dependencies. - When running in Azure Pipelines any existing SqlServer module is removed before running integration tests, so the tests can update to latest version. - Now the new label ''command proposal'' is an exempt for labeling issues stale. - Update the initializing header for all integration test to be equal to the unit tests. - Rename task jobs in Azure Pipelines ([issue #1881](https://github.com/dsccommunity/SqlServerDsc/issues/1881)). - `Get-SqlDscAudit` - The parameter `Name` is no longer mandatory. When left out all the current audits are returned ([issue #1812](https://github.com/dsccommunity/SqlServerDsc/issues/1812)). - `Import-SqlDscPreferredModule` - Now correctly preserves paths that is set in the session for the environment variable `$env:PSModulePath`. If the module _SqlServer_ or _SQLPS_ are not found the command will populate the `$env:PSModulePath` with the unique paths from all targets; session, user, and machine. This is done so that any new path that was added to the machine or user target will also be set in the session. - Now imports the preferred module into the global scope so that MOF-based resources (that is in another module scope) can use the imported module. - Some code cleanup ([issue #1881](https://github.com/dsccommunity/SqlServerDsc/issues/1881)). ### Fixed - `Assert-SetupActionProperties` - Now throws an exception if the setup action is `Install` and the feature analysis services is specified without the parameter `ASSysAdminAccounts` ([issue #1845](https://github.com/dsccommunity/SqlServerDsc/issues/1845)). - Now throws an exception if the setup action is `Install` and the feature database engine is specified without the parameter `SqlSysAdminAccounts`. - `Invoke-SetupAction` - The parameter `SqlSysAdminAccounts` is no longer mandatory to allow installation where the database engine is not installed. - `Install-SqlDscServer` - The parameter `SqlSysAdminAccounts` is no longer mandatory to allow installation where the database engine is not installed. - `SqlRS` - Fixed issue of configuring reporting services ([issue #1868](https://github.com/dsccommunity/SqlServerDsc/issues/1868)). - Test renamed to `When Reports virtual directory is different` so it is more correct and not a duplicate. - Integration tests configuration names was renamed to better tell what the configuration does ([issue #1880](https://github.com/dsccommunity/SqlServerDsc/issues/1880)). - SqlServerDsc.Common - The command `Restart-SqlService` was updated to correctly evaluate when the timeout value is reached ([issue #1889](https://github.com/dsccommunity/SqlServerDsc/issues/1889)). ' } # End of PSData hashtable } # End of PrivateData hashtable } |