Data Schema Comparison in Visual Studio 2010
By | September 18, 2011
 

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

 image thumb23 Data Schema Comparison in Visual Studio 2010

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

 image thumb24 Data Schema Comparison in Visual Studio 2010

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

image thumb25 Data Schema Comparison in Visual Studio 2010

Category: .NET Visual Studio Tags: ,

About The Author

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, ASP.net, AJAX, Web Services, Enterprise Library, Enterprise Applications, SharePoint 2010, Web Services, SQL Server (2008, 2005), Open Xml, MS Word Automation.