Post reply

Using TableDiff.exe ??

  • August 9, 2011 at 1:38 pm

    #241932

    Hello,

    I am trying to make use of this executable which is included in SQL.

    How to compare 2 tables (of different schema) with this utility.

    I am able to get the comparison results when the 2 tables have same column structure. But on a different schema, It simply throwing an Error stating that, these 2 tables can't be compared.

    Is there any other utilities in SQL, we can make use of.

    Thanks,

  • August 10, 2011 at 2:18 am

    #1366420

    I'll use the GUI tool of TableDiff.exe: http://code.google.com/p/sqltablediff/[/url]

    Maybe this could help to remove the error?

    But I think if you used the correct parameters, you will receive the same error with this tool, because it's using tablediff.exe

  • August 10, 2011 at 2:36 am

    #1366425

    Do you have to use only SQL tools ? There are a few easy to use DB compare tools available online.

    Other than TableDiff you could also try generating a Script for the tables and then compare the scripts in a text editor. Certain source control tools also allow you to compare different objects and highlight differences , VS and TFS comes to mind.

    Jayanth Kurup[/url]

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

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