Does anyone know of a free (as in cost) database schema comparison tool?

I just need a basic tool that compares the schema of two different databases and lets me know what the differences are. I don't necessarily need a tool to generate DDL scripts to automatically "merge" the differences.

As a hack, I used LLBLGen Pro's db refresh which does tell me that there are schema differences, but the output it's a little hard to translate into what I need. (This is not a complaint about LLBLGen. )

Thanks, -Ryan Casey

We script our database schemas out each night, if we want to id changes we then load 2 of them into winmerge.

This is pretty low tech, but is very free.

arschr wrote:

We script our database schemas out each night, if we want to id changes we then load 2 of them into winmerge.

Good idea...thanks.

arschr wrote:

We script our database schemas out each night, if we want to id changes we then load 2 of them into winmerge.

This is pretty low tech, but is very free.

This is a great suggestion. Thanks.

Something like this?

http://www.red-gate.com/SQL_Compare.htm

[Edit] Sorry, I just saw you were looking for something free. Never mind.