Visual Studio 2010 – Schema Compare Specific Object Compare

We have a requirement to compare two databases and we used the schema comparison tool in Visual Studio. We want to find the difference between the databases in terms of specific objects like SP, Functions and views. When we ignore the objects the script is not retuning any difference

Schema Compare

Schema Compare

Solution:
Deselect the Schemas option along with the SP, Functions and Views for comparison

Schema compare

Schema compare

Advertisements

About ambilykk

I am a Technology Evangelist on Microsoft Technologies. I am carrying the passion on Microsoft technologies specifically on web technologies such as ASP .Net and Ajax. My interests also include Azure and Visual Studio. Technology adoption and learning is my key strength and technology sharing is my passion.
This entry was posted in Visual Studio 2010 and tagged , . Bookmark the permalink.

One Response to Visual Studio 2010 – Schema Compare Specific Object Compare

  1. wyroby z betonu says:

    I really appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You’ve made my day! Thx again

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s