Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    CA
    Posts
    8

    Talking Unanswered: SQL script to compare two identical tables on two SQL servers

    Hi all,
    I have two tables A and B on two both tables have similar architectures bout contain some deferent records.

    I like to compare them and find and view the differences in records.


    Thanks for any help.

    Abrahim

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Best method I have come across so far:
    http://weblogs.sqlteam.com/jeffs/arc...1/10/2737.aspx

    Which version SQL Server? There is tablediff.exe (name??) for 2005. Not as easy to use as above - no idea how fast either. Results are in a text file so better suited for one offs unless you can write something to parse the output.

    Another 2005 option:
    http://weblogs.sqlteam.com/jeffs/arc.../02/60194.aspx
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    It is called tablediff.exe. Memory like an elephant me.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Another option is ApexSQL Diff. A trial is available, so you don't have to pay to test it.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •