Pipeline.Sql.Deploy.psd1
|
# # Module manifest for module 'Pipeline.Sql.Deploy' # # Generated by: Sabin.IO # # Generated on: 01/03/2026 # @{ # Script module or binary module file associated with this manifest. RootModule = 'Pipeline.Sql.Deploy.psm1' # Version number of this module. ModuleVersion = '0.0.22510780' # Supported PSEditions CompatiblePSEditions = 'Desktop', 'Core' # ID used to uniquely identify this module GUID = 'db6bb7de-c967-44dd-8bd2-5911fd271325' # Author of this module Author = 'Sabin.IO' # Company or vendor of this module CompanyName = 'Sabin.IO' # Copyright statement for this module Copyright = '(c) Sabin.IO 2019-2026. All rights reserved.' # Description of the functionality provided by this module Description = 'PowerShell module providing pipeline helper functions for SQL Server database deployments using DACPAC files. Includes intelligent deployment detection, settings comparison, and comprehensive SqlPackage.exe integration.' # Minimum version of the PowerShell engine required by this module PowerShellVersion = '5.1' # Name of the PowerShell host required by this module # PowerShellHostName = '' # Minimum version of the PowerShell host required by this module # PowerShellHostVersion = '' # Minimum version of Microsoft .NET Framework required by this module. This prerequisite is valid for the PowerShell Desktop edition only. # DotNetFrameworkVersion = '' # Minimum version of the common language runtime (CLR) required by this module. This prerequisite is valid for the PowerShell Desktop edition only. # ClrVersion = '' # Processor architecture (None, X86, Amd64) required by this module # ProcessorArchitecture = '' # Modules that must be imported into the global environment prior to importing this module # RequiredModules = @() # Assemblies that must be loaded prior to importing this module # RequiredAssemblies = @() # Script files (.ps1) that are run in the caller's environment prior to importing this module. # ScriptsToProcess = @() # Type files (.ps1xml) to be loaded when importing this module # TypesToProcess = @() # Format files (.ps1xml) to be loaded when importing this module # FormatsToProcess = @() # Modules to import as nested modules of the module specified in RootModule/ModuleToProcess NestedModules = @() # Functions to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no functions to export. FunctionsToExport = 'Get-DacPacHash', 'Get-DbSettingsAsJson', 'Get-DeployPropertiesJson', 'Invoke-DatabaseDacpacDeploy', 'Invoke-SqlScalar', 'New-SqlConnection', 'Save-DbSettingsToFile', 'Test-HaveDeploySettingsChangedSinceLastDeploy', 'Test-IsPreviousDeploySettingsFileMissing', 'Test-ShouldDeployDacpac', 'Write-DbDeployParameterLog' # Cmdlets to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no cmdlets to export. CmdletsToExport = @() # Variables to export from this module # VariablesToExport = @() # Aliases to export from this module, for best performance, do not use wildcards and do not delete the entry, use an empty array if there are no aliases to export. AliasesToExport = @() # DSC resources to export from this module # DscResourcesToExport = @() # List of all modules packaged with this module # ModuleList = @() # List of all files packaged with this module # FileList = @() # 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 = @{ # Tags applied to this module. These help with module discovery in online galleries. Tags = 'SQL','SqlServer','Database','Deployment','DACPAC','SqlPackage','Pipeline','DevOps','CI/CD','Azure','Automation' # A URL to the license for this module. LicenseUri = 'https://github.com/sabinio/Pipeline.Sql.Deploy/blob/main/LICENSE' # A URL to the main website for this project. ProjectUri = 'https://github.com/sabinio/Pipeline.Sql.Deploy' # A URL to an icon representing this module. # IconUri = '' # ReleaseNotes of this module ReleaseNotes = '# Pipeline.Sql.Deploy Release Notes ## Version 1.0.0 (2026-02-27) ### Major Features - **Complete IntelliSense Support**: Added comprehensive PowerShell help documentation for all public functions - **Enhanced Parameter Documentation**: All parameters now include detailed descriptions and examples - **Improved Module Metadata**: Added tags, project URLs, and better categorization for PowerShell Gallery ### Functions Enhanced - **Get-DacPacHash**: Calculate hashes for DACPAC files and dependencies to detect changes - **Invoke-DatabaseDacpacDeploy**: Execute DACPAC deployments with multiple authentication methods - **Save-DbSettingsToFile**: Serialize deployment settings for change detection - **Test-ShouldDeployDacpac**: Intelligent deployment decision engine with multiple criteria - **Test-HaveDeploySettingsChangedSinceLastDeploy**: Compare deployment configurations - **Test-IsPreviousDeploySettingsFileMissing**: Check for deployment history - **Write-DbDeployParameterLog**: Comprehensive deployment parameter logging ### Authentication Support - Windows Integrated Security - SQL Server Authentication - Azure Active Directory (Entra ID) - Access Token authentication - Service Principal authentication ### Deployment Features - Smart deployment detection (prevents unnecessary deployments) - DACPAC content hashing for change detection - Settings comparison between deployments - Support for SqlPackage.exe actions (Publish, Script, Report) - SQLCMD variable support - Azure SQL Database service objectives - Connection string and individual parameter support ### Breaking Changes - Updated minimum PowerShell version to 5.1 - Enhanced parameter validation and mandatory parameter enforcement - Improved error handling and logging ## Previous Versions ### Version 0.0.0.1 - Initial release with basic DACPAC deployment functionality - Core functions for database deployment pipeline integration' # Prerelease string of this module Prerelease = 'ci' # Flag to indicate whether the module requires explicit user acceptance for install/update/save # RequireLicenseAcceptance = $false # External dependent modules of this module # ExternalModuleDependencies = @() } # End of PSData hashtable } # End of PrivateData hashtable # HelpInfo URI of this module # HelpInfoURI = '' # Default prefix for commands exported from this module. Override the default prefix using Import-Module -Prefix. # DefaultCommandPrefix = '' } |