Redgate Hub

Product: SQL Compare

Compares and synchronizes SQL Server database schemas

All topics

All databases

All levels

SQL Compare logo

Handling System-named Constraints in SQL Compare

If some of your database constraints have system-generated names, they can cause 'false positives' when comparing schemas and generating build scripts using SQL Compare or SQL Change Automation. Phil Factor explains the difficulties, and the Compare option you need to enable to avoid them. Read more

SQL Source Control logo

Database Source Control in Azure Data Studio

How developers who were previously writing and managing database source code in SSMS can make a smooth transition to Azure Data Studio. Read more

SQL Compare logo

How to cope with Database Drift during Deployment using SQL Compare

Phil Factor on how to cope with any database drift that results from various checks and tests and fixes made during deployment. Read more

SQL Compare logo

The Database Development Stage

Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them. 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 Compare logo

Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script

Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing. Read more

SQL Compare logo

Database Build Breakers: Avoiding Constraint Violations during SQL Server Deployments

A common database build breaker is data that violates the conditions of any of the CHECK, UNIQUE or FOREIGN KEY constraints, and unique non-clustered indexes, designed to protect the consistency and integrity of your data. Phil Factor explain how to avoid this problem, using SQL Compare and some custom stored… Read more

SQL Compare logo

Custom Deployments from Source Control using SQL Compare Command line

Giorgi Abashidze explains how his team use a 2-phase deployment process with SQL Compare Command line, and some SQL Synonyms, to automate custom deployments for each of their customers, while only needing to maintain one branch per release in source control. 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

From Source Control to Database using SQL Compare Command Line

Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control. 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

Product: SQL Compare

Handling System-named Constraints in SQL Compare

Database Source Control in Azure Data Studio

How to cope with Database Drift during Deployment using SQL Compare

The Database Development Stage

SQL Server Database Deployment: What Could Go Wrong?

Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script

Database Build Breakers: Avoiding Constraint Violations during SQL Server Deployments

Custom Deployments from Source Control using SQL Compare Command line

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

From Source Control to Database using SQL Compare Command Line

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

Product: SQL Compare

Cookies on red-gate.com