Redgate Hub

Product: SQL Compare

Compares and synchronizes SQL Server database schemas

All topics

All databases

All levels

SQL Compare logo

Building a Database Directly from Object-level Source Scripts

Table manifests, and object manifests, which are just ordered lists, are a very useful output from and development database build. This article show how to generate a table manifest in SQL, and once you have it, you'll start to find several uses for it, besides the build process. Read more

Flyway logo

Creating Flyway Migration Files using Redgate Schema Comparison Tools

How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files. Read more

Flyway logo

Moving from 'Chaotic' to 'Managed' Database Development using Flyway

This article describes a route to adopting Flyway in order to bring management and control to a chaotic database development process. It is based on use of Flyway migrations to update a database from version to version, while maintaining object-level source scripts for tracking changes between versions. Read more

SQL Compare logo

Fine-tuning Scripted Database Comparisons with SQL Compare

When comparing databases, save your standard options and filters to a single project file, and then use PowerShell to script them out to the command line. This allows you to reuse the same project file across multiple comparison operations. Read more

SQL Compare logo

A Quick Diff Checker for SQL Server Databases

Compare the schemas of two SQL Server databases using SQL Compare command line then quickly produce a diff report showing you immediately which tables, views and functions have changed. Read more

Flyway logo

How Can Redgate Tools Help with a Cloud Migration?

The cloud migration tools and processes that will help you move a database to the cloud, from planning, implementation and validation through to extending existing development and deployment processes to the new cloud platform. Read more

SQL Compare logo

Automating SQL Compare Snapshots using SQL Snapper

If you have SQL Compare, then the SQL Snapper utility is very valuable 'extra' for certain team activities, because it can be freely distributed. It means that any developer can create a SQL Compare snapshot from databases that are on their local workstation and store them on the network. Read more

SQL Compare logo

Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet

SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database and its development data. For doing this routinely, I find it easiest to script the operation using PowerShell. Read more

SQL Compare logo

Maintaining a Database Build Script with SQL Compare

Phil Factor explores a lesser-known capability of SQL Compare, which is to help you maintain a 'traditional', well-documented, single file build script, for creating the current version of the database during development. Read more

SQL Compare logo

Database Deployments and Rocky Rollback Horrors: Where Does the New Data Go?

Phil Factor describes the problem of preserving data that is left 'in limbo' when you need to revert the database to a previous version that has no way of accommodating it. Read more

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

Product: SQL Compare

Building a Database Directly from Object-level Source Scripts

Creating Flyway Migration Files using Redgate Schema Comparison Tools

Moving from 'Chaotic' to 'Managed' Database Development using Flyway

Fine-tuning Scripted Database Comparisons with SQL Compare

A Quick Diff Checker for SQL Server Databases

How Can Redgate Tools Help with a Cloud Migration?

Automating SQL Compare Snapshots using SQL Snapper

Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet

Maintaining a Database Build Script with SQL Compare

Database Deployments and Rocky Rollback Horrors: Where Does the New Data Go?

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

Product: SQL Compare

Cookies on red-gate.com