Tag Archives: SQL Compare

A SQL Compare Picklist

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

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

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

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