Data Schema Comparison in Visual Studio 2010


Visual Studio 2010  has some inbuilt functionality as a tool to compare the different schemas .Schema comparison is a powerful tool that is used to compare database schemas. In tips I will give some basic step to compare schemas in Visual Studio 2010

  First launch the Schema Comparison tool from Data > Schema Compare > New Schema Comparison .

This will launch a New Schema Compare Tool where you can set Source and Target Schema


The result when source and target schema are same is displayed below


The result when source and target schema were somewhat different is displayed below


Subscribe To Newsletter For your Daily Development Tips and Tricks  

 Best Tips & Tricks on Microsoft Technology Platform 

Invalid email address
We promise not to spam you. You can unsubscribe at any time.
Atul Verma

I am working at Microsoft as a .NET Consultant. I have an experience of 5 years in .NET technologies and application packaging. My expertise include .NET Framework(4.0, 3.5, 3.0, 2.0), WPF, WCF,, AJAX, Web Services, Enterprise Library, Enterprise Applications, SharePoint 2010, Web Services, SQL Server (2008, 2005), Open Xml, MS Word Automation.