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

Forum for users of SQL Compare schema synchronization utility

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

Postby ttomsen » Wed Jul 16, 2014 5:20 pm

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.


Posts: 4
Joined: Thu Jun 21, 2012 1:56 pm
Location: United States

Postby Evan Moss » Fri Jul 18, 2014 6:51 pm


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.

Evan Moss
Product Support
(866) 627-8107
Evan Moss
Posts: 112
Joined: Wed Jun 12, 2013 9:56 pm

SQL Compare - Format differences

Postby DaleDeWitt » Wed Aug 20, 2014 3:09 pm

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.[b][/b]
Posts: 4
Joined: Wed Jun 11, 2008 5:11 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest