How to Compare Tables and its columns in 2 different servers RRS feed

  • Question

  • Hello All,

    I have 2 different servers. Dev and Test. I have some tables which starts with FM_ on both the servers. The table names are same in both the servers  but some of the column names in test server are different when it comes to dev. I would like to find what columns in the tables which starts with FM_ are different in Test server when compared with Dev. How to find this. Is there any script to find these. Please help.


    Thursday, August 9, 2012 4:40 PM