Redgate Hub

Topic: Database Builds and Deployments

SQL Change Automation (40)

All databases

All levels

SQL Change Automation logo

Database Continuous Integration with the Redgate SQL Toolbelt and Azure DevOps

Alex Yates shows how to set up automated processes for SQL Server database source control, build and continuous integration using Redgate SQL Toolbelt, Git and Azure DevOps Read more

SQL Change Automation logo

Database Development in Visual Studio using SQL Change Automation: Getting Started

Steve Jones shows how to set up a SQL Change Automation (SCA) project in Visual Studio, and import an existing database. As the team make database changes, either in SSMS or VS, they import them into the SCA project, which saves each change as a migration script that is then… Read more

SQL Change Automation logo

Documenting your Database with SQL Change Automation

Phil Factor uses SQL Change Automation and PowerShell to verify that the source code for the current database version builds successfully and, if so, to generate web-based database documentation using SQL Doc. Read more

SQL Change Automation logo

Practical PowerShell Processes with SQL Change Automation

Starting from the object-level source code for a database, Phil Factor shows how SCA can create a NuGet build package, use it to migrate target database to the same version, and publish web-based database documentation, a report of what changed on the target and the results of a static code… Read more

SQL Change Automation logo

Deploying Multiple Databases from Source Control using SQL Change Automation

How to automatically build multiple test databases, from source control, and then fill them with standard test data sets, using SQL Change Automation, BCP and some PowerShell magic. Read more

SQL Change Automation logo

SQL Change Automation with PowerShell Scripts: getting up-and-running

Provides a PowerShell automation script that will build a SQL Server database from the scripts in source control, document the database and then deploy it as a NuGet package, using it to update the schema of a live database. Read more

SQL Change Automation logo

SQL Code Analysis from a PowerShell Deployment Script

This article shows how to define SQL code analysis rules using SQL Prompt and them run them automatically from a PowerShell script, displaying the detected code issues in a handy HTML report. Read more

SQL Change Automation logo

What is SQL Change Automation?

This article describes the basic principles of SQL Change Automation, and how it works to provide a consistent and repeatable way of automating as much as possible of the database build, test, and deployment processes. 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 Change Automation logo

Database CI with Redgate SQL Change Automation, PowerShell and Jenkins

Alex Yates shows how to set up automated processes for SQL Server database source control, build and continuous integration using Redgate SQL Toolbelt, Subversion, and Jenkins Read more

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Assistant

Redgate Hub

Topic: Database Builds and Deployments

Database Continuous Integration with the Redgate SQL Toolbelt and Azure DevOps

Database Development in Visual Studio using SQL Change Automation: Getting Started

Documenting your Database with SQL Change Automation

Practical PowerShell Processes with SQL Change Automation

Deploying Multiple Databases from Source Control using SQL Change Automation

SQL Change Automation with PowerShell Scripts: getting up-and-running

SQL Code Analysis from a PowerShell Deployment Script

What is SQL Change Automation?

Moving from application automation to true DevOps by including the database

Database CI with Redgate SQL Change Automation, PowerShell and Jenkins

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Assistant

Topic: Database Builds and Deployments

Cookies on red-gate.com