compare db procs

is there a tool that will compare sp between 2 db for any difference only on the programmer's code?
LVL 5
25112Asked:
Who is Participating?
 
Éric MoreauSenior .Net ConsultantCommented:
0
 
25112Author Commented:
Staninix Database Compare does it, but it also include whitespaces.. I prefer it to be filtered and just compare programmers typed code..
0
 
25112Author Commented:
in the above tool, i prefer to avoid the false alarm.. the code is the same on most of the procs in these databases.. but the whitespaces comes off as difference..
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jogosCommented:
Visual studio if a (recent) version with db comparison included.
0
 
Scott PletcherSenior DBACommented:
For plain text comparisons, I like ExamDiff ... it's not a SQL tool, just a stand-alone Windows tool, so you would have to export the procs to text files.
0
 
25112Author Commented:
do the above tool have any option not to bother whitespaces..

let's say one db's proc ends with

END (space) (space) (space) (whitespace)

The other db's proc ends with

END (space) (space) (space)

This is flagged as different.. this brings lot of false +s.. can we avoid this with any of the above tools?
0
 
Scott PletcherSenior DBACommented:
ExamDiff has options for that.  You can tell it to ignore whitespace or to consider it.
0
 
25112Author Commented:
Scott, thanks - i see that option.. can you help me understand why the same line is looked differently by examdiff inspite of the options set as you said..
examdiff.bmp
0
 
jogosCommented:
A CR/LF  is not a whitespace I think
0
 
Scott PletcherSenior DBACommented:
I thought it had an option for CR/LF also, but maybe not.  I'm not an expert on it, I just like it :-) .  I'll take a look and let you know if I can find anything good.
0
 
25112Author Commented:
>>A CR/LF  is not a whitespace I think

thanks for confirming..

i would need a tool that can filter out CR/LF  too.. thanks
0
 
Scott PletcherSenior DBACommented:
But then you'd just have one giant line of text.

Just replace all the CR/LF with spaces before doing the compare :-) .

You will need a byte-by-byte compare tool then, though, of course.

Just remember, IBM has a really great compare tool, but don't know if it's available for Windows.
0
 
25112Author Commented:
good input
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.