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-SqlDscPreferredModule','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 = 'preview0011' # 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-preview0011] - 2023-04-10 ### 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. - New public command: - `Get-SqlDscPreferredModule` - Returns the name of the first available preferred module ([issue #1879](https://github.com/dsccommunity/SqlServerDsc/issues/1879)). - 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)). - SqlSetup - Added new parameter `ServerName` that will be used as the host name when evaluating the SQL Server instance. If using a secure connection the specified value should be the same name that is used in the certificate ([issue #1893](https://github.com/dsccommunity/SqlServerDsc/issues/1893)). ### 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)). - Bump SqlServer version to 22.0.59 for integration tests for SQL Server 2022. - `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)). - Refactor to re-use the command `Get-SqlDscPreferredModule`. - SqlServerDsc.Common - `Restart-SqlService` no longer silently ignores errors that prevents the instance to go online. If the instance has not gone online during the timeout period the error thrown will no contain the last error reported by `Connect-SQL` ([issue #1891](https://github.com/dsccommunity/SqlServerDsc/issues/1891)). - `Invoke-SqlScript` no longer passes the parameter `Variable` to `Invoke-SqlCmd` if it is not set ([issue #1896](https://github.com/dsccommunity/SqlServerDsc/issues/1896)). - `DatabasePermission` - Class was updated with the latest database permissions. ### 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 } |