Compare the data of 2 Tables (Updated)

  • G.R.Prithiviraj Kulasingham

    SSCarpal Tunnel

    Points: 4104

    Comments posted to this topic are about the item Compare the data of 2 Tables (Updated)

    Prithiviraj Kulasingham

  • Shiva-328755

    SSC Enthusiast

    Points: 164


    It's a great script that you have given us. Very handy to verify ETL migrations programmatically.

    Just to add (probably most of you already know this), there is a tool that comes with SQL Server called "TableDiff", which pretty much does the same. Only thing, it is a command prompt tool!




  • Preethiviraj Kulasingham

    Mr or Mrs. 500

    Points: 583


    Thank you for the note, sorry for the late response.

    Actually the code was first written in 2002 and I modified in 2004. I can't remember touching this code after that. When I wrote the code there weren't many tools for this purpose and I wrote it for personal use.

    This tool may have little value now as there are many tools available. But that was not the case when it was written. 🙂

    Prithiviraj Kulasingham

    Plan to Test your Plan!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply