Redgate Hub

All products

All topics

All databases

All levels

SQL Compare logo

Using the SQL Compare command line with Argfiles

Phil Factor demonstrates how using XML argfiles to pass parameters to SQL Compare cuts out a lot of the tedious scripting involved in modifying a database schema comparison and deployment process, as required for each target database. Read more

SQL Compare logo

Automating Schema Comparisons with SQL Compare Projects and PowerShell

A simple way of automating SQL Server database schema comparison and deployment tasks for multiple databases, by saving the options and configuration settings for each deployment in a project file and executing them from a PowerShell script. Read more

SQL Compare logo

Comparing and Deploying SQL Server Databases using the SQL Compare Command Line on Linux or Windows

SQL Compare now includes a Linux-based command line interface (CLI), as well as a Windows-based one, for doing schema comparison and deployments of SQL Server databases. This article offers worked examples of CLI scripts for various schema comparison tasks, to get you up and running with either version. Read more

SQL Compare logo

Handling Tricky Data Migrations during State-based Database Deployments

This article demonstrates how to use a 'state' approach to database source control, when the nature of the database changes cause you to hit difficulties with migrating existing data. These difficulties happen when the differences are such that it is impossible for any automated script to make the changes whilst… Read more

SQL Change Automation logo

Integrating SQL Server Tools into SQL Change Automation Deployments

Phil Factor shows how to integrate use of SQL Change Automation, SSMS registered servers, SMO, and BCP to automatically build or update a database on all servers in a group. Read more

SQL Change Automation logo

SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio

SQL Change Automation's Development component for developing new databases and modifying existing databases, using migrations, now integrates directly into SQL Server Management Studio as well Visual Studio. It allows teams to collaborate effectively during development, regardless of their preferred IDE, and in a way that integrates easily with common build/integration… Read more

Redgate Monitor logo

PowerShell Alert API and Server-level Permissions Overview in Redgate Monitor

SQL Clone logo

DevOps Self-Service for Databases with SQL Clone

Phil Factor describes the freedom of being able to "self-serve" databases, during testing and development, and explains how it works with SQL Clone. Read more

SQL Change Automation logo

You just Build It don't you? 12 Common Database Build Blockers

Database deployments, like the sheep of exasperated hill-farmers, often find strange and unexpected ways to self-destruct. Phil Factor describes the most common things that can go wrong, and how a reliable automated database build process can prevent messy accidents. Read more

Redgate Monitor logo

Monitoring TempDB Contention using Extended Events and Redgate Monitor

When the tempdb database is heavily used, processes in any database on the instance will be forced to wait, due to contention as the SQL Server engine tries to manage allocation pages in tempdb. Phil Factor shows how to monitor for signs of trouble. 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

Using the SQL Compare command line with Argfiles

Automating Schema Comparisons with SQL Compare Projects and PowerShell

Comparing and Deploying SQL Server Databases using the SQL Compare Command Line on Linux or Windows

Handling Tricky Data Migrations during State-based Database Deployments

Integrating SQL Server Tools into SQL Change Automation Deployments

SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio

PowerShell Alert API and Server-level Permissions Overview in Redgate Monitor

DevOps Self-Service for Databases with SQL Clone

You just Build It don't you? 12 Common Database Build Blockers

Monitoring TempDB Contention using Extended Events and Redgate Monitor

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

Cookies on red-gate.com