Home Forums SQL Server 2005 Development How to compare two tables on different databases RE: How to compare two tables on different databases

  • use tablediff utility : C:\Program Files\Microsoft SQL Server\90\COM

    give source and destination [servername , tablename , databasename]..

    simple to use (consult BOL).

    make sure that the table has unique/primary key (clustered index)

    HTH

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)