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

SQLCompare 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
>