How to Compare Tables and its columns in 2 different servers

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.

Thanks

Answer 1

Hello,

You can use linked server to do cross server queries.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing