Getting identical objects to show in SQL Compare

125 views Asked by At

Is there a way to get SQL Compare to output all objects, specifically stored procedures, in a database and not just those that differ?

2

There are 2 answers

0
db_brad On

In your compare results you should see a few different groupings. One being "identical objects". That one is on the bottom of my view. I am using SQL Compare 10.

0
Wonko On

If I want it to actually script all of the objects (rather than just see them in the results), I usually create an empty database and compare to that, then filter just to stored procedures and go through the synchronization wizard.