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

  • After you get the first compare done, you could add an update_dt field and have it default to the current getdate() value. Then, if there are dates since the last comparison, then those are the ones that are different.

    There's also merge replication, once you got them in a spot where they are the same.

    The EXCEPT is the way I would make that first compare, too.

    Randy