freeware to compare db shema ?

Do you know a simple toll to compare 2 database shemas ?
ThanksHaven't heard of any freeware. I use SQL Compare from RedGate.|||The poor mans approach is to use EM to generate a script for each db then use a tool to compare text files.|||If you are going to use it for a one time job ... you may prefer to try the demo version of sql compare.

Free tool to compare two databases

Hi,
Is there any free tool that compares the schema and the data of two SQL
Server databases ?
Thank youhttp://www.aspfaq.com/2209
But, FWIW, the cost of a refined tool will more than pay for itself in the
long run.
"Mark" <sauvemark@.yahoo.com> wrote in message
news:%23ppS1$KOGHA.3276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any free tool that compares the schema and the data of two SQL
> Server databases ?
> Thank you
>|||Also refer
http://www.downloaddatabase.com/dat...are/sqldiff.htm
http://www.sql-server-performance.c...mparison_sp.asp
Madhivanan|||You should be scripting each object seperately and managing them in a
version control system. Visual Source Safe, has a feature to compare scripts
between two projects (ex: FoodMart_DEV vs. FoodMart_PROD) and will visually
diplay the differences between the scripts. There is also the added benefit
of retaining previous versions of each script. Another free tool called
WinMerge that can visually compare differences between scripts and other
source files.
"Mark" <sauvemark@.yahoo.com> wrote in message
news:%23ppS1$KOGHA.3276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any free tool that compares the schema and the data of two SQL
> Server databases ?
> Thank you
>|||You can use SchemaCrawler, a free open-source tool that can compare
schemas as well as data. SchemaCrawler is a command-line tool to output
your database schema and data in a readable form. The output is
designed to be diff-ed with previous versions of your database schema.
http://schemacrawler.sourceforge.net/
Sualeh Fatehi.