Blank lines detected with compare, but not applied

mzcopea

We are using Sqlcompare commandline to create our scripts. We are noticing that Sql Compare produces a huge script when we don't expect to have many or any changes. What we have noticed is that Sqlcompare detects a change in functions, views or stored procedures that may just be an extra blank line.
Though it detects the blank line as a change, it doesn't make the change on the destination database objects. Therefore, week after week, we have the same script changes that only appear to be extra blank lines that never get applied.

Any ideas would be appreciated.

Tilman

Hi,

have you tried the IgnoreWhiteSpace option? It should be part of the default options. To specify it explicitely add:

/options:IgnoreWhiteSpace

to your command.

For more information on options see the verbose help of the command line, i.e.

sqlcompare /help /verbose.

Let me know if that helps.

Tilman

mzcopea

YES! Wonderful! My compare script went from 1.7 meg to 12KB. This will eliminate some of our build problems because the script would run into constraint issues unneccesarily due to attempting to make changes that were unneeded.

It's the little things that mean so much.

Thanks!