Visual Studio 2010 – Schema Compare Specific Object Compare

Posted on August 15, 2012 by ambilykk

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

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.

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

  1. wyroby z betonu says:
    August 16, 2012 at 1:37 pm

    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

    Reply

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Cancel

Connecting to %s