Redgate Hub

Topic: Database Builds and Deployments

All products

All databases

All levels

SQL Compare logo

How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory

Describing SQL Compare's built-in Active Directory Authentication mode, which makes it easier and more secure to, for example, deploy schema changes from version control to an Azure SQL Database. Read more

SQL Compare logo

How to deploy a database plus static data using SQL Compare and SQL Data Compare

Tony Davis shows how to get a database, plus any static data, into source control, and then uses the "/include:StaticData" switch in the SQL Compare Pro command line, fromPowerShell, to automate the process of creating a new build script. Read more

SQL Change Automation logo

Moving from application automation to true DevOps by including the database

This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the… Read more

SQL Compare logo

Automating database deployments to and from source control using SQL Compare and PowerShell

How to use SQL Compare Pro command line with PowerShell to automate the processes of getting a new database into source control, updating the source with the latest database changes, creating a new build script for a database version, and creating a deployment script to synchronize an existing database with… Read more

SQL Compare logo

Automatically keeping 'hotfix' and production database schemas in sync

How to use the SQL Compare Pro command line to automatically compare the schema of two versions of the same database, and then subsequently deploy to the target database any differences detected in the source database. Read more

SQL Data Generator logo

How to build-and-fill multiple development databases using PowerShell and SQL Data Generator

This article offers a build-and-fill method for development databases, where each developer will subsequently want to alter the data or metadata in his or her copy of the database. Read more

SQL Data Generator logo

How to Automatically Fill your SQL Server Test Databases with Dummy Data

A PowerShell script to automatically populate a SQL Server database with dummy data, for database development and testing work. Read more

SQL Compare logo

How to build multiple database versions from the same source: pre-deploy migration scripts

The final part of Alex Yates's three-part series tackles the complicated issue of automating deployments when the same table might have a different structure, in different production versions of the database. Read more

SQL Compare logo

Automating DacPac deployments using the SQL Compare command line and PowerShell

How to extract a database migration script, or a database build script, from a DacPac and then use it in a PowerShell-automated database deployment. Read more

SQL Compare logo

How to build multiple database versions from the same source: post-deploy scripts

In Part 2 of his series, Alex Yates shows how to use a combination of post-deployment scripts to handle cases where a code object exists in multiple production instances, but in different states. Read more

Previous Next

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Hub

Topic: Database Builds and Deployments

How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory

How to deploy a database plus static data using SQL Compare and SQL Data Compare

Moving from application automation to true DevOps by including the database

Automating database deployments to and from source control using SQL Compare and PowerShell

Automatically keeping 'hotfix' and production database schemas in sync

How to build-and-fill multiple development databases using PowerShell and SQL Data Generator

How to Automatically Fill your SQL Server Test Databases with Dummy Data

How to build multiple database versions from the same source: pre-deploy migration scripts

Automating DacPac deployments using the SQL Compare command line and PowerShell

How to build multiple database versions from the same source: post-deploy scripts

2025 Stand der Datenbank-Landschaft

Einführung in PostgreSQL für den Datenprofi

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Topic: Database Builds and Deployments

Cookies on red-gate.com