Tag Archives: SQL Compare

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 , | Leave a comment

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 , , | Leave a comment

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

Getting the Script from the SQL Compare Command Line

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