Deployment service

As explained in 100 SQL Server Mistakes and How to Avoid Them

A deployment service is an automated service that delivers packaged software to target environments in a release sequence.

A deployment service promotes a built database package through release environments, moving from development or integration testing toward UAT, staging, and production. section 7.6.2

A practical deployment flow connects these elements:

• Source control stores merged changes and triggers the release process. section 7.6.2
• Build services run tests and create the DAC package as a dacpac file. section 7.6.2
• Deployment services promote the dacpac through environments, with human gates varying by environment. section 7.6.2

Named deployment tools

Octopus Deploy, Azure DevOps, and Redgate Deploy can deploy a DAC first to a lower environment and then onward after sign-off. section 7.6.2

Figure 7.9 CI/CD process

Use the CI/CD process diagram to follow how work moves from development through builds, deployment services, environments, and production. section 7.6.2

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes

Explains pipeline sequencing and human gates but stops short of detailed deployment-tool configuration.

Examples

Uses Octopus Deploy, Azure DevOps, Redgate Deploy, DAC packages, and staged development-to-production environments.

What it assumes

Assumes source control and build services that test code and produce a dacpac package.

What you can do after

Operate deployment services to promote a tested DAC through environments while retaining appropriate human approval gates.

How it connects

Connects deployment services with CI/CD pipelines, source control, build services, dacpac files, and environments.

liveBookmanning.com

Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  Effective Platform EngineeringA deployment service is a system component that performs application deployments to a target runtime environment.
• 

  liveBookmanning.com
  LLMs in ProductionA deployment service is a software service that configures, provisions, and exposes trained machine-learning models for inference in an operational environment.

Compare how 3 books explain deployment service →

Related concepts

• data-tier applicationuses · A data-tier application is an application architecture component that encapsulates database schema, data, and related database deployment or management artifacts.
• Kubernetesuses · Kubernetes is an open-source platform for orchestrating and automating the deployment, scaling, and management of containerized workloads across computing clusters.
• mlopsused by · MLOps is the discipline of applying engineering and operational practices to develop, deploy, monitor, maintain, and manage machine-learning systems throughout their life cycle.
• deployment pipelineuses · A sequence of automated or manual stages that builds, tests or validates, packages, and delivers software or models toward deployment.
• Helmuses · Helm is a Kubernetes package manager and templating tool that defines, packages, installs, upgrades, and manages applications through charts.

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.