Skip to content
← SQL Compare

How can we improve SQL Compare?

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Format compare using SQL Prompt format

Ability to format the source and destination code to ensure compare is using the same structure.

157 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Brandon shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    Woot! Happy 11th, but it's in! Thanks Brandon for taking my tweet and getting it put in here. : )

  • Anonymous commented  ·   ·  Report

    Happy 8th birthday to this request. :(

  • Daniel White commented  ·   ·  Report

    When I check in a change that is only reformatting, I put "(format sql)" or "(no change)" or something similar in the check-in comment. You could make that a convention, then other developers would know where not to waster their time.

    That said, I also believe that formatting the code automatically for every compare would be a great feature.

  • Vladimir Oselsky commented  ·   ·  Report

    Having the ability to format code is great but so often the only change that happens in development is code formatting. If we can format code during compare it would resolve a lot of false-positive tests that require a lot of time to dig through to find actual changes.

  • Michael Søndergaard commented  ·   ·  Report

    I totally agree, you guys have all the building blocks for implementing this feature, so it should be easy and fast to implement.

    It should be a no brainer, when you consider all the votes and the time it should take to implementing this.

  • Shawn C commented  ·   ·  Report

    Given SQL Compare *adds" square brackets to object names that don't exist in sys.sql_modules, this would be very usefu

  • Wes commented  ·   ·  Report

    This would be a huge improvement over Visual Studios schema compare.

  • Dani Avni commented  ·   ·  Report

    3 years and still not implemented... when will this be implemented?

  • J. Verdurmen commented  ·   ·  Report

    That would save a lot of "false positives" (and time)!

  • Johannes commented  ·   ·  Report

    YES PLEASE!! Currently I have to reformat both sides using SQL Prompt then run SQL compare again to see the actual changes. This would be a great feature and would also help to implement formatting to databases automatically so that ALL the objects always conforms to the format layout as specified in SQL Prompt's configuration.