Home > Archive > MS SQL Server ODBC > May 2005 > Compare 2 DB









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Compare 2 DB
Marcelo Moreira

2005-05-24, 7:23 am

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


Jacco Schalkwijk

2005-05-24, 7:23 am

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
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com