Re: Compare 2 DB

Tech-Archive recommends: Fix windows errors by optimizing your registry

SQLCompare from www.red-gate.com is the tool I use for that.

--
Jacco Schalkwijk
SQL Server MVP


"Marcelo Moreira" <marcelo.moreira@xxxxxxxxxxxxxxx> wrote in message
news:eoh%234BEYFHA.252@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • Compare 2 DB
    ... I need to compare 2 DB (Tables, Colums etc) in order two calculate/determine ... It would be great if this aplication would also be able to ...
    (microsoft.public.sqlserver.odbc)
  • Re: help me on this audit trail trigger
    ... INSERTED and DELETED tables and compare the rows as Dan has suggested. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Does Yucon support set ansi_nulls?
    ... So if I have to compare fields for inequality then the ... Can I Know the exact maximum limit of query string allowed? ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Compare Fields in the Same Table
    ... If you only want identical matches, ... "Josh Gerszewski" wrote in message ... >> SQL Server MVP ... >>> I'd like to compare two text fields in the same table using a select ...
    (microsoft.public.sqlserver.programming)
  • Re: Exclude Spaces
    ... Dan Guzman ... SQL Server MVP ... I want to compare two cloumns n two different tables excluding spaces. ...
    (microsoft.public.sqlserver.server)