Redgate Hub

SQL Change Automation (64)

All topics

All databases

All levels

SQL Change Automation logo

Simple Database Development with SQL Change Automation

SQL Change Automation makes automation simple enough that it can adapt to suit many different approaches to SQL Server database development. Phil Factor describes a project to update the Pubs database, using it in combination with a PowerShell function and to maintain in source control the build scripts, migration scripts… Read more

SQL Clone logo

Getting Started with Automatic Database Branch Switching

Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control. Read more

SQL Change Automation logo

Allowing for manual checks and changes during database deployments

SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a… Read more

SQL Clone logo

How SQL Clone and SQL Change Automation enable seamless Database Branch Switching

Learn how SQL Clone and SQL Change Automation, used together, now allow you to branch your database in Git as quickly and simply as your code. Read more

SQL Change Automation logo

SQL Server Database Deployment: What Could Go Wrong?

Phil Factor tackles the tricky questions you will need to answer when deciding how to automate your SQL Server database builds and deployments with Redgate's development, version control and deployment tools. Read more

SQL Change Automation logo

How to Add a Filter to an Existing SQL Change Automation Project

Kendra Little demonstrates how to create a SQL Compare filter file and save it to a SQL Change Automation project folder, so that it will be used automatically during development. Read more

SQL Change Automation logo

Using SQL Change Automation in SSMS to Track Static Data Changes

SQL Change Automation 4.1 now allows users to develop static data changes from SQL Server Management Studio. Read more

SQL Compare logo

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything… Read more

SQL Compare logo

Using Custom Deployment Scripts with SQL Compare or SQL Change Automation

Phil Factor describes how custom pre- and post-deployment scripts work, when doing state-based database deployments with SQL Compare or SQL Change Automation, and how you might use them to, for example, add a version number to the target database, specify its database settings, or stuff data into some tables. Read more

SQL Change Automation logo

Recreating Databases from Scratch with SQL Change Automation

Phil Factor starts with the basics how to rebuild a set of development database from scratch, using SQL Change Automation, and then demonstrates how to check for any active sessions before rebuilding, import test data using BCP, and secure passwords if connecting to the target with SQL Server credentials. Read more

Previous Next

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 Hub

Simple Database Development with SQL Change Automation

Getting Started with Automatic Database Branch Switching

Allowing for manual checks and changes during database deployments

How SQL Clone and SQL Change Automation enable seamless Database Branch Switching

SQL Server Database Deployment: What Could Go Wrong?

How to Add a Filter to an Existing SQL Change Automation Project

Using SQL Change Automation in SSMS to Track Static Data Changes

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

Using Custom Deployment Scripts with SQL Compare or SQL Change Automation

Recreating Databases from Scratch with SQL Change Automation

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

Cookies on red-gate.com