Pipeline.Sql.Deploy
0.0.22510704-ci
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 PowerShell version
5.1
See the version list below for details.
Installation Options
Owners
Copyright
(c) Sabin.IO 2019-2026. All rights reserved.
Package Details
Author(s)
- Sabin.IO
Tags
SQL SqlServer Database Deployment DACPAC SqlPackage Pipeline DevOps CI/CD Azure Automation
Functions
Get-DacPacHash Get-DbSettingsAsJson Get-DeployPropertiesJson Invoke-DatabaseDacpacDeploy Invoke-SqlScalar New-SqlConnection Save-DbSettingsToFile Test-HaveDeploySettingsChangedSinceLastDeploy Test-IsPreviousDeploySettingsFileMissing Test-ShouldDeployDacpac Write-DbDeployParameterLog
PSEditions
Dependencies
This module has no dependencies.
Release Notes
# 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
FileList
- Pipeline.Sql.Deploy.nuspec
- Pipeline.Sql.Deploy.psm1
- Functions\Get-DbSettingsAsJson.ps1
- Functions\Invoke-DatabaseDacpacDeploy.ps1
- Functions\New-SqlConnection.ps1
- Functions\Test-HaveDeploySettingsChangedSinceLastDeploy.ps1
- Functions\Test-ShouldDeployDacpac.ps1
- Functions\Internal\Add-ToList.ps1
- Functions\Internal\Get-ConnectionString.ps1
- Functions\Internal\Get-DeployPropertiesHash.ps1
- Functions\Internal\Get-DeploySettingsFromDB.ps1
- Functions\Internal\Get-DeploySettingsFromFile.ps1
- Functions\Internal\Get-EntraAccessToken.ps1
- Functions\Internal\Get-ModelChecksum.ps1
- Functions\Internal\Get-ReferencedDacpacsFromModel.ps1
- Functions\Internal\Get-SettingsAsJson.ps1
- Functions\Internal\Invoke-Query.ps1
- Functions\Internal\Invoke-SqlScalar.ps1
- Functions\Internal\New-SqlConnection.ps1
- Functions\Internal\Test-DatabaseExists.ps1
- Pipeline.Sql.Deploy.psd1
- Functions\Get-DacPacHash.ps1
- Functions\Get-DeployPropertiesJson.ps1
- Functions\Invoke-SqlScalar.ps1
- Functions\Save-DbSettingsToFile.ps1
- Functions\Test-IsPreviousDeploySettingsFileMissing.ps1
- Functions\Write-DbDeployParameterLog.ps1
- Functions\Internal\Convert-ToSQLPackageSafeString.ps1
- Functions\Internal\Get-DefaultSettingsToCheck.ps1
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 1.0.9-ci | 2 | 2/27/2026 |
| 1.0.8-ci | 2 | 2/27/2026 |
| 1.0.6 | 277 | 2/8/2026 |
| 1.0.6-ci | 3 | 2/8/2026 |
| 1.0.4 | 16 | 2/8/2026 |
| 1.0.4-ci | 3 | 2/8/2026 |
| 1.0.2 | 24 | 2/8/2026 |
| 1.0.2-ci | 3 | 2/8/2026 |
| 0.0.22510781-ci | 3 | 3/1/2026 |
| 0.0.22510780-ci | 3 | 3/1/2026 |
| 0.0.22510775-ci | 3 | 3/1/2026 |
| 0.0.22510704-ci (current version) | 3 | 3/1/2026 |
| 0.0.157 | 1,606 | 6/24/2024 |
| 0.0.157-ci | 5 | 6/24/2024 |
| 0.0.150 | 261 | 6/30/2022 |
| 0.0.150-ci | 13 | 6/30/2022 |
| 0.0.148 | 20 | 6/28/2022 |
| 0.0.148-ci | 14 | 6/28/2022 |
| 0.0.145 | 24 | 6/2/2022 |
| 0.0.145-ci | 14 | 6/2/2022 |
| 0.0.142 | 22 | 5/25/2022 |
| 0.0.142-ci | 14 | 5/25/2022 |
| 0.0.136 | 32 | 4/13/2022 |
| 0.0.130 | 19 | 4/8/2022 |
| 0.0.126 | 18 | 4/8/2022 |
| 0.0.124 | 19 | 4/7/2022 |
| 0.0.124-ci | 14 | 4/7/2022 |
| 0.0.120 | 31 | 3/3/2022 |
| 0.0.120-ci | 14 | 3/3/2022 |
| 0.0.117 | 17 | 3/3/2022 |
| 0.0.117-ci | 14 | 3/3/2022 |
| 0.0.115 | 21 | 3/1/2022 |
| 0.0.115-ci | 14 | 3/1/2022 |
| 0.0.102 | 135 | 8/26/2021 |
| 0.0.102-ci | 15 | 8/26/2021 |
| 0.0.96 | 42 | 7/22/2021 |
| 0.0.96-ci | 15 | 7/22/2021 |
| 0.0.95 | 16 | 7/22/2021 |
| 0.0.95-ci | 14 | 7/22/2021 |
| 0.0.93 | 20 | 7/17/2021 |
| 0.0.93-ci | 20 | 7/17/2021 |
| 0.0.92-ci | 14 | 7/16/2021 |
| 0.0.90-ci | 13 | 7/16/2021 |
| 0.0.89 | 16 | 7/16/2021 |
| 0.0.89-ci | 14 | 7/16/2021 |
| 0.0.67 | 20 | 7/16/2021 |
| 0.0.67-ci | 14 | 7/16/2021 |
| 0.0.66 | 30 | 7/14/2021 |
| 0.0.66-ci | 14 | 7/14/2021 |
| 0.0.65-ci | 14 | 7/14/2021 |
| 0.0.61 | 19 | 7/14/2021 |
| 0.0.61-ci | 14 | 7/14/2021 |
| 0.0.59 | 17 | 7/14/2021 |
| 0.0.59-ci | 14 | 7/14/2021 |
| 0.0.53 | 18 | 7/13/2021 |
| 0.0.53-ci | 14 | 7/13/2021 |
| 0.0.49 | 16 | 7/13/2021 |
| 0.0.49-ci | 19 | 7/13/2021 |
| 0.0.47 | 16 | 7/13/2021 |
| 0.0.47-ci | 14 | 7/13/2021 |
| 0.0.46 | 16 | 7/13/2021 |
| 0.0.46-ci | 17 | 7/13/2021 |
| 0.0.44 | 21 | 7/13/2021 |
| 0.0.44-ci | 15 | 7/13/2021 |
| 0.0.42-ci | 14 | 7/13/2021 |
| 0.0.20 | 65 | 1/22/2021 |
| 0.0.20-ci | 16 | 1/22/2021 |
| 0.0.19 | 25 | 1/22/2021 |
| 0.0.19-ci | 17 | 1/22/2021 |
| 0.0.15 | 19 | 1/21/2021 |
| 0.0.15-ci | 17 | 1/21/2021 |
| 0.0.12 | 48 | 1/19/2021 |
| 0.0.12-ci | 16 | 1/19/2021 |
| 0.0.11 | 18 | 1/19/2021 |
| 0.0.11-ci | 15 | 1/19/2021 |
| 0.0.10-ci | 15 | 7/13/2021 |
| 0.0.9 | 18 | 1/18/2021 |
| 0.0.9-ci | 17 | 1/18/2021 |
| 0.0.6 | 20 | 1/18/2021 |