Tag Archives: SQL Compare

Search and Replace Three Part Names with SQL Compare

Posted on April 25, 2022 by way0utwest

A customer had an interesting challenge in their codebase recently, and I thought this would make a good post. This involves SQL Compare and three part names. The Scenario A customer was using SQL Compare and they wanted to update … Continue reading →

Posted in Blog | Tagged , | Comments Off on Search and Replace Three Part Names with SQL Compare

Ensuring SQL Compare Checks Synonyms

Posted on April 13, 2022 by way0utwest

I was running a PoC for a customer and they noticed that synonyms were being missed when they changed the database being used. It was surprising to me, but it turns out the solution is simple. This post explains how … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Ensuring SQL Compare Checks Synonyms

Ignoring System Generated Key Names in SQL Compare

Posted on August 9, 2021 by way0utwest

Recently I ran into a customer that was having issues deploying code from their development system to their production system. The issue was that they often found that the deployment script wanted to drop and recreate their keys. This wasn’t … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Ignoring System Generated Key Names in SQL Compare

Getting the Script from the SQL Compare Command Line

Posted on July 5, 2021 by way0utwest

In the last few posts, I’ve written about using the SQL Compare command line for a specific object and shown how to get a report. This post will look at getting the actual script. When we run the command line … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Getting the Script from the SQL Compare Command Line