Compare 2 DB

Hi,
I need to compare 2 DB (Tables, Colums etc) in order two calculate/determine
the difference between both, does somebody knows an aplication which is able
to do this? It would be great if this aplication would also be able to
create a script, after comparison, which aplies to one of the DB what the
other has differente/more. I hope I made understand myself!! :-) If the
aplication is able to compare two Tables would be enough.
I apreciate any help, thanks.
MarceloSQLCompare from www.red-gate.com is the tool I use for that.
Jacco Schalkwijk
SQL Server MVP
"Marcelo Moreira" <marcelo.moreira@.vpconsulting.pt> wrote in message
news:eoh%234BEYFHA.252@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I need to compare 2 DB (Tables, Colums etc) in order two
> calculate/determine the difference between both, does somebody knows an
> aplication which is able to do this? It would be great if this aplication
> would also be able to create a script, after comparison, which aplies to
> one of the DB what the other has differente/more. I hope I made understand
> myself!! :-) If the aplication is able to compare two Tables would be
> enough.
> I apreciate any help, thanks.
> Marcelo
>