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

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

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
ttomsen
0

Comments

2 comments

Sort by
  • Evan Moss
    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
    0
  • DaleDeWitt
    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.
    DaleDeWitt
    0

Add comment

Please sign in to leave a comment.