Deployment

Publish-DbaDacPackage

Richie lee (@richiebzzzt)

Publish-DbaDacPackage View Source Richie lee (@richiebzzzt) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Deploys DACPAC or BACPAC files to SQL Server databases using the DacFx framework Description Deploys database schema changes from DACPAC files created by SSDT projects or Export-DbaDacPackage, automatically updating target database structure and executing embedded pre/post deployment scripts. Also imports data from BACPAC files for complete database restoration scenarios.

Save-DbaKbUpdate

Chrissy LeMaire (@cl), netnerds.net

Save-DbaKbUpdate View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Downloads Microsoft Knowledge Base updates and patches to local storage Description Downloads Microsoft KB updates, cumulative updates, and service packs from Microsoft’s servers to your local file system. This function handles SQL Server patches as well as any other Microsoft KB updates, making it easy to stage patches for installation across multiple servers.

Update-DbaInstance

Kirill Kravtsov (@nvarscar), nvarscar.wordpress.com

Update-DbaInstance View Source Kirill Kravtsov (@nvarscar), nvarscar.wordpress.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Installs SQL Server Service Packs and Cumulative Updates across local and remote instances automatically. Description Automates the complete process of applying SQL Server patches to eliminate the manual effort of updating multiple instances. This function handles the entire patching workflow from detection through installation, replacing the tedious process of manually downloading, transferring, and applying updates across your SQL Server environment.

← Previous

1 2

Page 2 of 2