SQL Compare

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

SQL Monitor

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn't. But one particularly common culprit is when deployments go wrong: I don't know a single DBA who hasn't been burned by a bad release. Read more