How to compare database differences?
Working with databases is often a tedious task. When deploying a new database, or deploy changes within the database to production, you want to be sure that the schema is right. Not only the changes to the schema are important, but also the contents of views and stored procedures need to be compared.
However, it is hard to compare databases and schemas on the same server, or between servers. Additionally, it is a time consuming and often recurring task.
Therefore we added the 'Compare database' functionality to the SQL DataTool. We made it as easy as possible to use, and saves time. This article covers how to compare databases using the SQL DataTool.