Fine-tuning Scripted Database Comparisons with SQL Compare

When comparing databases, save your standard options and filters to a single project file, and then use PowerShell to script them out to the command line. This allows you to reuse the same project file across multiple comparison operations. Read more

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

Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask

Phil Factor offers straightforward answers to tricky SQL Compare questions. Read more

Exploring the SQL Compare Options

You need to compare database schema objects in two SQL Server databases, and then automatically generate a SQL deployment script that when executed will remove these differences, either making the schema of the target database match the source, or vice-versa. It sounds easy, but the problems lie in the details of the schema comparison options. Read more

Handling System-named Constraints in SQL Compare

If some of your database constraints have system-generated names, they can cause 'false positives' when comparing schemas and generating build scripts using SQL Compare or SQL Change Automation. Phil Factor explains the difficulties, and the Compare option you need to enable to avoid them. Read more

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

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

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

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

A whole new way to see differences in SQL Compare

SQL Compare 12.4 adds the Summary view, a tab that sits alongside SQL view and provides a more concise breakdown of the differences between two objects. Read more