[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • Last Modified:

SQL Server 2008/2012: comparing tables data in two databases

Hi, we have two versions of the same database and want to be able to compare data in the tables from time to time to make sure the data is the same or to know the differences.

What do you think is the best way to implement this?

2 Solutions
Russell FoxDatabase DeveloperCommented:
You'll either need to code a custom solution or get a 3rd party product like Open DBDiff or Redgate's SQL Compare.
Vikas GargBusiness Intelligence DeveloperCommented:

For your case I think Replication will be best suited which can be unidirectional or bidirectional so that you can synchronize your tables for two different databases.
Scott PletcherSenior DBACommented:
MS provides a free command-line tool, "tablediff.exe".  Like bcp and/or format files, it's somewhat tricky to get working the first time, but it's pretty good overall considering that it's free :-) .  I believe at least one vendor even offers "older"/"baby" version of its compare too free, but that's just from memory, and I don't recall the details.

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now