feature request, maybe it's already in there....

ttomsenttomsen Posts: 7
edited August 20, 2014 10:09AM in SQL Compare Previous Versions
It would be nice, if sql prompt was run on sql text so to normalize the sql.

for example:

we have a database with 1000's of stored procs, we bought redgate tool belt with sql prompt. Someone uses SQL format to update a 1000 line stored proc, when we use sql compare it looks way out of synch , when in reality it's just the formatting.... no real code changes.

Is there a feature in sql compare to use sql prompt to normalize the two stored procs, making a compare WAY more usefull. If not, please

make this a feature of sql compare it would be invaluable with a team using different formatting patterns.

Thanks

Tyler

Comments

  • Hello,

    Thanks for your post.

    You should be able to modify the comparison options to ignore whitespace and ignore comments -- this should stop your stored procedures from showing as differences.

    Please let me know if you have further questions.

    Regards,
    Evan
    Evan Moss
    Product Support
    (866) 627-8107
  • Is it possible to run the SQL Prompt - Format SQL before the compare is done ?? The reason being is if there is more than one person developing in a database, and they have their format options set differently in the SQL Prompts Format SQL options.... IE, commas leading instead of trailing, SC throws a code difference when there really isn't one.... If the SQL Format could be run on both sides of the compare before the compare is done, it would provide better/more accurate results... When you have hundreds of changes, this would be very helpful.
Sign In or Register to comment.