What is a free tool to compare two SQL Server Databases? [closed]

by

TableDiff.exe should have everything you need. It is one of the hidden gems in SQL Server 2005. So you don’t have to download anything.

• Table Difference tool allows you to discover and reconcile differences between a source and destination table or a view. Tablediff Utility can report differences on schema and data. The most popular feature of tablediff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. TableDiff.exe takes 2 sets of input;
• Connectivity – Provide source and destination objects and connectivity information.

• Compare Options – Select one of the compare options
• Compare schemas: Regular or Strict

• Compare using Rowcounts, Hashes or Column comparisons

• Generate difference scripts with I/U/D statements to synchronize destination to the source.
TableDiff was intended for replication but can easily apply to any scenario where you need to compare data and schema.
You can find more information about command line utilities and the Tablediff Utility in Books Online for SQL Server 2005.

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. Export from SQL Server to Excel
  3. hide/remove header and footer
  4. How do I generate a random number for each row in a T-SQL select?
  5. Combine multiple results in a subquery into a single comma-separated value
  6. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  7. SQL Server: SELECT only the rows with MAX(DATE)
  8. Floor a date in SQL server
  9. LEN function not including trailing spaces in SQL Server
  10. How FOR XML PATH(”) works when concatenating rows
  11. How to view transaction logs in SQL Server 2008 [closed]
  12. Scheduled run of stored procedure on SQL server
  13. SQL Server ORDER BY date and nulls last
  14. SSRS 2014 report deploy issue
  15. Best way to implement an audit trail in SQL Server?
  16. Set start value for column with autoincrement
  17. tsql returning a table from a function or store procedure
  18. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  19. Making an Entity Framework Model span multiple databases
  20. SQL Server 2008 Row Insert and Update timestamps
  21. “Prevent saving changes that require the table to be re-created” negative effects
  22. What are the differences between Merge Join and Lookup transformations in SSIS?
  23. Convert UTC Milliseconds to DATETIME in SQL server
  24. Table Valued Function Killing My Query Performance
  25. freeTDS not using its config
  26. @@ERROR and/or TRY – CATCH
  27. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  28. How to make a passthrough / passthru query editable?
  29. How to do Sql Server CE table update from another table
  30. Tool for Scripting Table Data

Leave a Comment