I am new to sql server user but I had good experience on MySql + SqlYog tool
I want to compare structure as well as data between two different databases located at two different server on sql server.
1) As we have information_schema in Mysql, do we have similar option ( or any other alternative ) on Sql Server 2008?
2) As we have schema synchronization tool under powertools option inside SQLyog tool
do we have similar option ( or any other alternative ) on Sql Server 2008?
Any help will be appreciated,