Post reply

Compare data in two tables

  • February 1, 2006 at 6:58 am

    #112369

    Hi,

    has anybody used the "tablediff utility" in SQL 2005, if so please let me know how to go about using this utility. I would like to use this to compare data in two tables - Thanks much in advance -

    Regards!

  • February 2, 2006 at 6:08 am

    #618357

    I haven't used the "tablediff utility" in SQL 2005. However, I do have to compare the data in tables quite often.  I have found Red Gate's SQL Data Compare to be a great tool.  I am not sure if you are looking to spend money or if the amount of times you need to do a data compare justifies such a purchase.  However, I have really found it to be a great tool for a the price.

    Have a good day,

    Norene Malaney

  • February 2, 2006 at 7:55 am

    #618397

    There are several products "out there" to do comparisons of both structure and data. I'll agree with Norene that Red Gate is a good product, but I've also checked out SQLDelta and a few others. Most are reasonably priced and well worth the money.

    Cheers,

    Ken

  • February 2, 2006 at 11:35 am

    #618461

    BCP out the two tables to saprate files use NT/Unix diff utility

    H. Singh

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

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