Open Dbdiff 0.9

The SQL Server migration process often occurs, requiring a difference between two databases, or between tables

SQL Server's Tablediff Utility is a command-line tool that is rather unfriendly to an occasional experience

Https://msdn.microsoft.com/en-us/library/ms162843.aspx

If it's just a comparison of the tables, it could be that the data source is directly glued to Excel, for spreadsheet Compare (with this tool in Office 2013) to compare

Of course, if the amount of data is large, and there are multiple tables, it will be more troublesome.

Introduction of a CodePlex (this site is actually some open source projects of Microsoft, and free trial) on the tool open Dbdiff 0.9.

http://opendbiff.codeplex.com/releases/view/72756

In fact, this tool is very simple, after downloading the direct zip decompression can be used directly.

Basically the object can be synchronized, but the data is to follow the table to synchronize. It is also recommended that you review the statements generated below to make changes before synchronizing.

There are a few things to be aware of, because it is a graphical tool that can be mis-operated, and if not, an appropriate backup would be more difficult to recover.

So there are a few suggestions.

If it is single-use, directly set the database to read-only, of course, after the completion of the work will be set back.

1  Use [Master]2 GO3 ALTER DATABASE [AdventureWorks2012] SETRead_Only withno_wait4 GO5 6  Use [Master]7 GO8 ALTER DATABASE [AdventureWorks2012] SETRead_write withno_wait9 GO

Microsoft SQL Server Community Projects & Samples

https://sqlserversamples.codeplex.com/

Open Dbdiff 0.9