In this article, I have provided list of various tools and options to compare two Sql database schema’s, which can be be very useful for Database developers.
1. DBComparer
This is a free professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures or you can even use it for new version like 2012 or 2014. It is an excellent tool for any project development team or DBA managing multiple copies of the same database on an SQL Server
This database comparison tool has a clean and straight-forward user interface. Results are clearly presented so that you can immediately see the differences in your databases
Features:
- Automate compare database
- Compare all database objects or selected ones only
- Free to use
- Advanced visual build tree interface for an intuitive visual representation of any differences
- Compare databases using all or selected object properties
- Built-in text differences control with SQL syntax highlighting
Different Ways to Compare SQL Server Tables Schema and Data
SQL Server provides us with different solutions to replicate or archive a database table or tables to another database, or the same database with different names. As an SQL Server Developer or Database Administrator, you may face situations when you need to check that the data in these two tables are identical, and if, by mistake, the data is not replicated between these two tables, you need to synchronize the data between the tables. In addition, if you receive an error message, that breaks the data synchronization or replication process, due to schema differences between the source and destination tables, you need to find an easy and fast way to identify the schema differences, ALTER the tables to make the schema identical in both sides and resume the data synchronization process.
In other situations, you need an easy way to get the YES or NO answer, if the data and schema of two tables are identical or not. In this article, we will go through the different ways to compare the data and schema between two tables. The provided methods in this article will compare tables that are hosted in different databases, which is the more complicated scenario, and can be also easily used to compare the tables located in the same database with different names.