How can we help you today? How can we help you today?

Blank lines detected with compare, but not applied

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.
mzcopea
0

Comments

2 comments

Sort by
  • 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
    Tilman
    0
  • 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!
    mzcopea
    0

Add comment

Please sign in to leave a comment.