Post reply

DB Compare

  • November 25, 2005 at 7:37 am

    #95949

    Hey SQL Gurus, can any help in comparing the structure as well as schema of two db using T-SQL query. I have tried with a tool but i want to know how it could be done using query

    regards,

    Abdul

     

     

  • November 28, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • November 28, 2005 at 7:39 pm

    #606291

    browse the forums on this site... there is a DBA writing exactly what you are looking for and a list of people getting in line to receive it   You might also want to browse the scripts elsewhere on this site as I believe I have seen this written before.

    Cheers,

    david russell

  • November 29, 2005 at 6:23 am

    #606386

    I would say that you would need to query the contents of the INFORMATION_SCHEMA views and compare the data in them.  You will need to use names, not internal IDs, and basically you want to do a compare of A-B, B-A and A<>B.

    Red-Gate's SQL Compare is a heck of a lot easier, and their SQL Data Compare is excellent for looking at the data comparison.

    I bought my own copies before I convinced the company to buy them.  I would have kept them even if the company didn't pay.

     

    Brian

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

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