What is the best tool to compare SQL Server database schemas across different db servers?

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.

1 I have used it at both schema and data level. Excellent tool. +1 – David M Mar 13 at 20:11 give it time...david atkinson is going to be all over this – kelloti Mar 13 at 20:13.

Sql Examiner will compare database on different servers. I'm not sure about the schema but there is a demoversion 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.

SQL Compare is not cheap. Moreover, it is much more expensive than most competitors – SQLDev Mar 14 at 15:54 @SQLDev: examples then please, perhaps so we can compare features too. – gbn Mar 14 at 18:49 For example, SQL Examiner Suite, mentioned in this topic previously.

I'm using this tool, and as far as I know, the tool allows much more than SQL Compare (for example, SQL Examiner works with MSSQL, MySQL, Oracle vs. MSSQL only in SQL Compare). SQL Examiner costs $300 only (compare with ~$700-800 for SQL Compare). You can find more cheaper tools with Google :) – SQLDev Mar 15 at 18:02.

Database tools from Embarcadero seems to work well. embarcadero.com/solutions/microsoft-sql-... 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.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.