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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Éric MoreauSenior .Net ConsultantCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.