SQL Compare

Product learning

How to create and refresh development and test databases automatically, using SQL Clone and SQL Toolbelt

Phil Factor shows how a set of Redgate tools can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers. Before tearing down and rebuilding a database to a new version, we take care to save any DDL changes made to the existing copy. Read more

SQL Compare

Retrospective Database Source Control with SQL Compare

You've found a database that is not in source control. What do you do? Phil Factor shows how to use SQL Compare to generate all the missing object scripts, in Git, and then keep them up-to-date automatically, in response to any further database changes, during development. Read more

SQL Compare

SQL Compare Snapshots: a lightweight database version control and rollback mechanism

During the proof-of-concept phase of development work, SQL Compare Snapshots offer an easy way to work out what broke, if a change causes some tests to fail, as well as a simple ‘roll back’ technique to return quickly to the last working copy. Read more

SQL Compare

How to reformat a database in one operation

Inherited a database from another team? Changed your team policy on the way that you format SQL? What's to stop you formatting the code of an entire database nicely, when you're developing it? Manually, the process can take longer than you expect. Phil Factor demonstrates a simple 3-step approach to reformatting a whole database , in a single operation, using SQL Compare and SQL Prompt. Read more

SQL Compare

Keeping track of history: SQL Compare and Temporal Tables

Asha Patel introduces SQL Compare 13's support for deploying changes to temporal tables, Read more

SQL Compare

How to Customize Schema Comparisons using Auto Map in SQL Compare

How the table automapping feature works in SQL Compare, and how to control its behavior. Read more

SQL Compare

Introducing the updated HTML comparison report in SQL Compare 13.1

SQL Compare 13.1 brings improvements to the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases. Read more

SQL Compare

Remembering passwords in SQL Compare and SQL Data Compare

SQL Compare or SQL Data Compare can automatically populate your SQL Server credentials, if you wish. Just check the "Remember credentials" box, and passwords will now be stored in two places: the Windows Credential Store and your project file, if you save one. Read more

SQL Compare

How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory

Describing SQL Compare's built-in Active Directory Authentication mode, which makes it easier and more secure to, for example, deploy schema changes from version control to an Azure SQL Database. Read more

SQL Compare

How to examine differences with SQL Compare Summary View and SQL View

Jamie Wallis introduces the new Summary View, which is a tab that sits alongside SQL View and provides a more concise breakdown of the differences between two objects. Read more