sql - Tips abouts comparing to database tables. Table Diff -

Please share your tips on comparing tables:

• Display rows To have a similar value, a given set of columns
• not displaying the rows contained in the table A. But the table B &

  I have always been a fan of redgate tools.

  Provides very flexible options to compare tables / databases with criteria based on rows, columns, filters, etc. E.g.

  

  for this database tables A diff tool for text files that happens, for example, it is particularly useful when trying to distinguish between the data constellations between the dev and the production server. To apply changes to a server on another server, there is also a very easy feature to generate SQL statements based on delta.