Home Forums SQL Server 2005 SQL Server 2005 General Discussion Automate script for comparing two tables RE: Automate script for comparing two tables

  • March 4, 2008 at 4:38 am

    #784842

    sangeethasriram18 (3/4/2008)

    Hi,

    Any idea on how to build a sql script for comparing the data between two tables in a database with similar attributes and non similar attributes?

    Another note 🙂 There are third party tools for data comparison in your tables in case you need to do this frequently, need a nice UI, have the data in different databases/different servers, need to do full or partial migration/merge

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software