How to compare store procedures from different databases

Question

1.00/5 (1 vote)

See more:

Is there some tool we can use to compare and synchronize stored procedures? Requirements are simple. We need to compare stored procedures from separate databases and find mismatch data.

Posted 29-Apr-13 8:52am

Walterls

Add a Solution

Comments

Sergey Alexandrovich Kryukov 29-Apr-13 15:04pm

Not clear. What should be the result of comparison? Why?
—SA

3 solutions

Solution 2

Visual Studio 2010 Premium an Ultimate have Schema compare Tool which compares and programmability objects.
Red Gate has pricy but excellent line of tools for similar tasks.

Posted 29-Apr-13 21:41pm

Oshtri Deka

Solution 3

Store all sto proc code blocks/scripts/.sql/etc in tables in a database. Enable full-text search. Or not.

Posted 30-Apr-13 8:48am

RedDk

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

smagent · Accepted Answer · 2013-04-29T09:21:00

We are using ApexSQL Diff[^] You can use this tool to both compare objects and sync either from tool directly or create synchronization script.

If you’re not into third party tools you can try doing this manually by comparing sys schema tables. More specifically sys.syscomments tables on both servers.