Data Compare feature missing in Visual Studio 2012?

I cannot find Data Compare in Visual Studio 2012. Schema compare is there.

Was it removed? Or is it hidden somewhere?

Solution 1:

Someone already opened up a ticket on Connect for this. The answer from Microsoft as of 3/13/2012 was that they have not yet implemented the feature in the new SQL Server Data Tools used by Visual Studio 11, but that they plan to add it in the future.

The work around is to use the VS 2010 data compare.

Solution 2:

You can install it with the SQL Server Data Tools - June 2013 update

http://msdn.microsoft.com/en-us/jj650015

Solution 3:

Also take a look at http://msdn.microsoft.com/en-us/data/tools.aspx. This "seems" to be replacing the data tools that came with Visual Studio 2010 and is how updates are being distributed.

Also waiting for data compare!!

Chuck

Solution 4:

If you are going against SQL Server 2012, the workaround from VS2010 Data Compare will not work. VS2010 Data Compare only seems to work on SQL 2008R2 (and maybe on older versions too)

Solution 5:

You need to download SSDT to compare sql server data. It's does not came with visual studio. However you can also use Master Data visual studio addin to compare sql server databases .. It's lightweight(1mb) and also includes some advance feature over SSDT ..