Redgate Hub

Topic: Database Source Control

SQL Toolbelt (78)

All databases

All levels

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

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

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

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

SQL Compare logo

How to build multiple database versions from the same source: object filters

How to use filters in SQL Compare to avoid deploying objects that exist only in the source to databases where they may not be required or appropriate. Read more

SQL Source Control logo

Versioning an existing database using SQL Source Control

How to bring an existing database under Git version control. Read more

SQL Compare logo

How to create a directory of object-level scripts using SQL Compare

How to create a directory of object-level scripts from an existing database using SQL Compare GUI or command line. Read more

SQL Source Control logo

Source controlling your database permissions

How to use a combination of database roles, along with rules, filters and post deployment scripts in SQL Source Control, to add the required users to the correct role, for each database. Read more

SQL Source Control logo

Source controlling database users

Where developers have their own databases, you need to ensure the user accounts are configured identically across all development and test server, or you'll inevitably hear the phrase “…but it works on my machine”. Alex Yates describes, strategically, how this might work. 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 Test Data Manager

Redgate Hub

Topic: Database Source Control

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

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

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

Database CI with Redgate SQL Change Automation, PowerShell and Jenkins

How to build multiple database versions from the same source: object filters

Versioning an existing database using SQL Source Control

How to create a directory of object-level scripts using SQL Compare

Source controlling your database permissions

Source controlling database users

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 Test Data Manager

Topic: Database Source Control

Cookies on red-gate.com