Techbubbles

Schema Compare for SQL Server in Visual Studio 2013

This post outlines the new Schema Compare and Data Compare features in Visual Studio 2013 which supports SQL Server and Windows Azure databases. Schema Compare provides the capability to analyse and compare database schema along with presenting the results in visual and highly configurable manner.It can also calculate the actions necessary that affects the changes on the source. It supports databases and database projects.

If you want to compare your working database project with the database then you can use the schema compare, right click on your database project and select Schema Compare it then brings the schema comparison window

image

select the target database in you schema compare window by clicking on target dropdown

image

Before you click on compare window you can choose different comparison options as shown below

image

once you click the Compare button it then presents the differences in results window

image

You click the Update button to apply the changes. While it is updating the changes you can see the progress in Data Tools Operations window.

image

Data Comparison compares the data between two existing databases of the same schema and reports the differences graphically, It can also runs through the scripts that necessary to apply the changes. To check the data between two databases is same click the tools menu select SQL Server and click New Data Comparison option

image

Choose the Source and Target databases and click next as shown in the following picture

image

Select the tables and views that you want to compare, it compares the data based on primary key between the tables

image

once you click the finish it then shows you the results as shown below

image

you can go throw the records to see the difference, the values that are different shown in bold. Click on Update, Add and Delete cells in results grid. Check the records that you want to update, add or delete and then click update target button. Schema and Data Compare tools are incredibly powerful and flexible to quickly see the differences between your database environments.

Related Posts:

%d bloggers like this: