Tag Archives: SQL Compare

A SQL Compare Picklist

Posted on December 19, 2022 by way0utwest

Recently a customer was trying to sync up production and development. They’d somewhat lost control of both environments and wanted to build a plan of how to sync them. This post covers a process I suggested to them to tackle … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on A SQL Compare Picklist

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