Redgate logo
  • Products
    • All products
    • Automate database deployments
      • Redgate Deploy
    • Monitor performance and availability
      • SQL Monitor
    • Standardize team-based development
      • SQL Toolbelt
      • SQL Prompt
      • SQL Search
      • Flyway
      • SQL Source Control
      • Source Control for Oracle
      • SQL Compare
      • Schema Compare for Oracle
      • SQL Data Compare
      • Data Compare for Oracle
    • Protect and preserve data
      • SQL Provision
      • Data Masker
      • SQL Clone
      • SQL Backup
      • SQL Data Catalog
    • .NET
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Performance Profiler
      • ANTS Memory Profiler
      • SmartAssembly
    • All products
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Memory Profiler
      • ANTS Performance Profiler
      • Data Compare for Oracle
      • Data Masker
      • Flyway
      • Redgate Deploy
      • Schema Compare for Oracle
      • SmartAssembly
      • Source Control for Oracle
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • SQL Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
      • SQL Toolbelt
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Automate
      • Monitor
      • Protect
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • Finance
      • U.S. Federal
      • Healthcare
      • Manager Service Providers
    • Resources
    • Maturity assessment
  • Support
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Press kit
  • Community Hub
    • Community Hub home
    • Community Circle
    • Product learning
    • Redgate University
    • Forums
    • Events & groups
    • Simple Talk
  • Search
  • My account
  • Shopping cart
  • Your quotes
  • Buy now
    • See all products
    • View price list
    • Request a quote
    • Contact sales
    • Your account
  • Products
    • All products
    • Automate database deployments
      • Redgate Deploy
    • Monitor performance and availability
      • SQL Monitor
    • Standardize team-based development
      • SQL Toolbelt
      • SQL Prompt
      • SQL Search
      • Flyway
      • SQL Source Control
      • Source Control for Oracle
      • SQL Compare
      • Schema Compare for Oracle
      • SQL Data Compare
      • Data Compare for Oracle
    • Protect and preserve data
      • SQL Provision
      • Data Masker
      • SQL Clone
      • SQL Backup
      • SQL Data Catalog
    • .NET
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Performance Profiler
      • ANTS Memory Profiler
      • SmartAssembly
    • All products
      • .NET Developer Bundle
      • .NET Reflector
      • ANTS Memory Profiler
      • ANTS Performance Profiler
      • Data Compare for Oracle
      • Data Masker
      • Flyway
      • Redgate Deploy
      • Schema Compare for Oracle
      • SmartAssembly
      • Source Control for Oracle
      • SQL Backup
      • SQL Clone
      • SQL Compare
      • SQL Data Catalog
      • SQL Data Compare
      • SQL Data Generator
      • SQL Dependency Tracker
      • SQL Doc
      • SQL Index Manager
      • SQL Monitor
      • SQL Multi Script
      • SQL Prompt
      • SQL Provision
      • SQL Scripts Manager
      • SQL Search
      • SQL Source Control
      • SQL Test
      • SQL Toolbelt
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Automate
      • Monitor
      • Protect
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • Finance
      • U.S. Federal
      • Healthcare
      • Manager Service Providers
    • Resources
    • Maturity assessment
  • Support
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Press kit
  • Community Hub
    • Community Hub home
    • Community Circle
    • Product learning
    • Redgate University
    • Forums
    • Events & groups
    • Simple Talk

OVERVIEW

  • Compliant Database DevOps

BY NEED

  • Standardize team-based development
  • Automate database deployments
  • Monitor performance and availability
  • Protect and preserve data

BY ROLE

  • Development
  • Operations
  • IT Management
  • Enterprise leadership

BY INDUSTRY

  • Tech
  • Finance
  • U.S. Federal
  • Healthcare
  • Managed Service Providers

Redgate Hub

  • Community Circle Together we learn
  • Product articles Tips & how-to guides
  • University Product training videos
  • Community forums Ask, discuss, solve
  • Events & Friends Meet us & join in
  • Simple Talk Articles & opinion

Product articles
SQL Data Compare
Database Testing

  • SQL Data Compare
  • Data Deployments
  • Database Testing

Comparing and Syncing Data using SQL Data Compare Command Line

Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes. Read more

  • SQL Data Compare
  • Database Testing

Testing SQL Server Stored Procedures and Functions with SQL Data Compare

Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies. Read more

  • SQL Change Automation
  • SQL Data Compare
  • Generating Realistic Test Data
  • Database Testing

Build and fill a database using JSON and SQL Change Automation

Phil Factor demonstrates how to export data from a database, as JSON files, validate it using JSON Schema, then build a fresh development copy of the database using SQL Change Automation, and import all the test data from the JSON files. Read more

Products

  • SQL Change Automation
  • SQL Clone
  • SQL Compare
  • SQL Data Compare
  • SQL Data Generator
  • SQL Prompt
  • SQL Provision
  • SQL Test
  • SQL Toolbelt

Filter by level

Product Articles

Tips and how-to guides for Redgate products

University

Easy to follow video courses

Community Forums

Ask, discuss, and solve questions about Redgate's tools

Events & Friends

Meet us at an event, get sponsored, and join our Friends of Redgate

Simple Talk

In-depth articles and opinion from Redgate's technical journal

The Redgate Update Get the latest news and training with the monthly Redgate Update Sign up

Products

  • Automate
  • Monitor
  • Standardize
  • Protect & preserve

Support

  • Forums
  • Contact product support
  • Find my serial numbers
  • Download older versions

Solutions

  • Overview
  • Maturity Assessment

Our Company

  • Careers
  • Contact us
  • Redgate Blog
  • Our values

Community & Learning

  • Product Learning
  • University
  • Events & Friends
  • Simple Talk
  • Books
  • Forums

Partners

  • SQL Server Central
  • Resellers
  • Consulting partners

Privacy & compliance

  • Privacy and cookies
  • License agreement
  • Accessibility
  • Report security issue
  • Modern slavery
  • CCPA - Do not sell my data

Follow us

Redgate on Twitter Redgate on LinkedIn Redgate on YouTube
  • Copyright 1999 - 2020 Red Gate Software Ltd