SQL Compare

SQL Compare

How to Customize Schema Comparisons using Auto Map in SQL Compare

It’s a tedious task to have to compare two versions of a SQL script, side by side, for example to find differences between the version of the script on Production, and the one on the Test system. As a developer, you must try to spot the real code differences in among the ‘noise’. The task Read more

SQL Compare

Introducing the updated HTML comparison report in SQL Compare 13.1

Whether you need to deploy changes, or simply view the differences between two SQL Server databases, SQL Compare helps you do the job quickly and accurately by exploring what’s changed in each database object, down to individual lines of SQL. In SQL Compare 13.1, we’ve updated the interactive HTML comparison report type, providing simpler cleaner Read more

SQL Compare

Remembering passwords in SQL Compare and SQL Data Compare

We’ve recently added a feature to automatically populate your SQL Server credentials when you’re using SQL Compare or SQL Data Compare. If you check the Remember credentials box, passwords will now be stored in two places: the Windows Credential Store and your project file if you save one. The project file has long been a Read more

SQL Compare

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

Microsoft introduced Azure Active Directory (AAD) as a secure way to manage credentials for access to the different offerings available on the Azure platform, including Microsoft Azure SQL Database. It integrates with existing on-premise Windows Server Active Directory, so users require only a single Windows credential for secure access to both on-premise SQL Server instances, Read more

SQL Compare

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

During the recent Redgate Hub Launch Livestream Steve Jones introduced the new Summary View, which is available now in SQL Compare. The brand new Summary View is a tab that sits alongside SQL View and provides a more concise breakdown of the differences between two objects. We have achieved this by getting rid of the Read more

SQL Toolbelt

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. To Read more

SQL Compare

A whole new way to see differences in SQL Compare

In the latest release of SQL Compare, we’ve added a brand new way to examine the differences between two objects in your database. Until now, SQL Compare has relied on the SQL difference viewer to convey the differences between an object in the source database and its counterpart in the target database: Don’t worry, this Read more

SQL Compare

How to deploy a database plus static data using SQL Compare and SQL Data Compare

We can use the SQL Compare Pro command line with PowerShell to automate the process of creating a new build script for a version of the database, from the object scripts in the VCS. However, what if we want to include static data in the build? This article describes how to the use the SQL Read more

SQL Compare

Automating database deployments to and from source control using SQL Compare and PowerShell

Our goal is to show how to use SQL Compare Pro command line with PowerShell to automate the following processes: Getting a new database into version control, or updating the object scripts in the VCS to reflect the latest database changes Creating a new build script for a database version, from the object scripts in Read more

SQL Compare

Automatically keeping ‘hotfix’ and production database schemas in sync

In this article, I’ll be showing you how to automatically compare the schema of two versions of the same database, and then subsequently deploy to the target database any differences detected in the source database. In other words, for any database object that exists in both databases but with differences, the object’s definition in the Read more