Redgate logo
  • Products
    • All products
    • Automate database deployments
      • Flyway Enterprise
    • Monitor performance and availability
      • SQL Monitor
    • Standardize team-based development
      • 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
      • 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
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Automate
      • Monitor
      • Protect
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • Finance
      • U.S. Federal
      • Australian Government
      • Healthcare
      • Manager Service Providers
    • Resources
    • Maturity assessment
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Press kit
  • Support
  • Learning & community
    • Learning & community | Redgate Hub
    • Product articles
    • University
    • Events
    • Forums
    • Community
    • Simple Talk
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart
  • Products
    • All products
    • Automate database deployments
      • Flyway Enterprise
    • Monitor performance and availability
      • SQL Monitor
    • Standardize team-based development
      • 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
      • 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
  • Solutions
    • Overview
    • By Need
      • Standardize
      • Automate
      • Monitor
      • Protect
    • By Role
      • Development
      • Operations
      • IT Management
      • Enterprise leadership
    • By Industry
      • Tech
      • Finance
      • U.S. Federal
      • Australian Government
      • Healthcare
      • Manager Service Providers
    • Resources
    • Maturity assessment
  • Our Company
    • Overview
    • Careers
    • Contact us
    • Redgate blog
    • Press kit
  • Support
  • Learning & community
    • Learning & community | Redgate Hub
    • Product articles
    • University
    • Events
    • Forums
    • Community
    • Simple Talk
  • Buy now
    • See all products
    • Request a quote
    • Contact sales
    • My account
    • Shopping cart

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
  • Australian Government
  • Healthcare
  • Managed Service Providers
PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

Redgate Hub

  • Product articles
  • University
  • Events
  • Forums
  • Community
  • Simple Talk

Product articles
SQL Compare
Database Builds and Deployments

  • SQL Compare
  • Database Builds and Deployments

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

  • SQL Compare
  • Database Builds and Deployments

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

  • Redgate Deploy
  • SQL Compare
  • Database Source Control
  • Database Builds and Deployments

Branching and Merging in Database Development using Flyway

How to exploit the branching and merging capabilities of Git for scaling up team-based development, when doing Flyway migrations. Read more

  • SQL Compare
  • Database Builds and Deployments

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
  • Database Builds and Deployments

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
  • Database Builds and Deployments

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
  • Database Builds and Deployments

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

  • SQL Change Automation
  • SQL Compare
  • Database Builds and Deployments

Database Build Blockers: Four-part Object References

Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms. Read more

  • SQL Change Automation
  • SQL Compare
  • Database Builds and Deployments

Database Updates: Roll Back or Fix Forward?

Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update. Read more

  • SQL Toolbelt
  • SQL Compare
  • Database DevOps
  • Database Builds and Deployments

Database DevOps for Pragmatists: A Datafaction Case Study

Ami Adler, a Software Development Manager at Datafaction explains how they used Redgate tools, and others, to introduce automation and testing into their Database DevOps processes and so achieved a faster and more reliable deployment process for their application. Read more

Products

  • Deployment Suite for Oracle
  • Flyway
  • Redgate Deploy
  • SQL Change Automation
  • SQL Clone
  • SQL Compare
  • SQL Data Compare
  • SQL Data Generator
  • SQL Doc
  • SQL Prompt
  • SQL Provision
  • SQL Source Control
  • SQL Toolbelt

Filter by level

Next
  • 1
  • 2
  • 3
  • 4
  • 5

Redgate Hub

  • Product Articles

    Product Articles

    Tips and how-to guides for Redgate products

  • University

    University

    Easy to follow video courses

  • Events

    Events

    Join us online, or get sponsored

  • Forums

    Forums

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

  • Community

    Community

    Develop your skills and meet Redgate Advocates and Friends

  • Simple Talk

    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
  • Gender pay gap report
  • CCPA - Do not sell my data

Follow us

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