Tag Archives: SQL Compare

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

Command Line Report with SQL Compare 14

Posted on June 28, 2021 by way0utwest

I wrote recently about the use of the command line in SQL Compare 14 to find differences for specific items. Now I want to actually see the changes to decide what to do. In the previous post, I saw the … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Command Line Report with SQL Compare 14

Using SQL Compare for One Procedure

Posted on June 11, 2021 by way0utwest

A customer recently was concerned about the time to run SQL Compare for a large database. They were synching with the command line, but at times they want to just sync up a procedure or two from one database to … Continue reading →

Posted in Blog | Tagged , , | 4 Comments