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


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.