What is best tool to compare two SQL Server databases (schema and data)? [duplicate]

by

I use schema and data comparison functionality built into the latest version Microsoft Visual Studio 2015 Community Edition (Free) or Professional / Premium / Ultimate edition. Works like a charm!

img

http://channel9.msdn.com/Events/Visual-Studio/Launch-2013/VS108

Red-Gate’s SQL data comparison tool is my second alternative:

img
(source: spaanjaars.com)

More Related Contents:

  1. How can I schedule a job to run a SQL query daily?
  2. What’s the best practice for primary keys in tables? [closed]
  3. Reset identity seed after deleting records in SQL Server
  4. How to create multiple one to one’s
  5. Generate a resultset of incrementing dates in TSQL
  6. T-SQL Cast versus Convert
  7. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  8. How to replace a string in a SQL Server Table Column
  9. How would you implement sequences in Microsoft SQL Server?
  10. What does =* mean?
  11. How to run a stored procedure in sql server every hour?
  12. Splitting the string in sql server
  13. Composite Primary key vs additional “ID” column?
  14. Query comparing dates in SQL
  15. Why do you create a View in a database?
  16. Need to list all triggers in SQL Server database with table name and table’s schema
  17. How can I do a BEFORE UPDATED trigger with sql server?
  18. Favourite performance tuning tricks [closed]
  19. Deferrable Constraints in SQL Server
  20. How to sum up time field in SQL Server
  21. Know relationships between all the tables of database in SQL Server
  22. Can SQL Server Express LocalDB be connected to remotely?
  23. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  24. Using SQL Server as a DB queue with multiple clients
  25. Suggestions for implementing audit tables in SQL Server?
  26. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  27. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  28. Functions vs Stored Procedures
  29. Executing SQL query on multiple databases
  30. Single or multiple databases

Leave a Comment