what is the best tool to compare SQL Server database schemas across different db servers [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

i have to compare two SQL server databases:

1. The databases are on different db servers (i see a few tools but they assume both databases are on the same db server which falls short of my requirements)
2. I want to compare at the sch开发者_如何学运维ema level because one database has a number of different schemas in it and I only want to compare one schema.

are there any good tools to do this?

---

The best tool I've come across for doing this is SQLCompare from RedGate. I've never needed to use it to compare at the schema level though.

---

Sql Examiner will compare database on different servers. I'm not sure about the schema but there is a demoversion

http://www.sqlaccessories.com/Default.aspx

It will also generate scripts to update one database to match the other. I have used the demo version and was impressed. They also have a tool that does the same with your data.

---

Red Gate Compare tools offers the features you need. That is, fine grained filtering. Different servers should be standard in any tool IMO.

But they aren't free, however still cheaper than their competitors

---

Database tools from Embarcadero seems to work well.

http://www.embarcadero.com/solutions/microsoft-sql-server

They have an option on most of their products for the mode software-on-USB that you can take with you to run without installation.

---

AdeptSQL Diff http://www.adeptsql.com/