SQL Server Performance

Tablediff workaround with different schema

Discussion in 'SQL Server 2005 Replication' started by Fais, Feb 27, 2009.

  1. Fais New Member

    I am trying to use Tablediff utility to compare publisher and subscriber tables.
    The problem is :
    At Publisher side : we have Table_A & Table_B.
    At Subsciber side: On Table_A, there is a addional column ( added by someone) ,which inserts the curent datetime thourht default constraint.
    The problem is : When I am trying to compare this two table data through 'tablediff.exe', it says schema are different , which is true. However, both the table data is similar but the difference is there is one additional column on subsciber side.
    Can anyone know ,how to work around this issue.
    Thanks....Appreciate your help.
  2. Fais New Member

    Now, I created the view and then started comparing tables. Now I am receiving TIMEOUT EXPIRED error. I can ping both the servers back & forth.

    Also I have used -t switch in the command line to specify timing, still it is timing out.

    Error : Timeout expired. The timeout periiod elapsed prior to completion of operation or the server is not responding.

    Can someone please help here.

    Thanks.

Share This Page