Sql Server 2008 structure + data Comparisions of two different databases

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,
shahjagatAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dbbishopCommented:
Do you have the other database set up as a linked server? There is a product we use called SQL Compare by Red Gate. A two-week fully functional trial version is available. It will let you compare every single aspect of the schema, including extended properties, indexes, constraints, triggers, etc., or you can tailor it to which components to compare. As long as SQL Compare has access to both databases, it will function.
0
dbbishopCommented:
Of course, the 'quick and dirty' way would be to generate scripts for both databases as a single file, and then use a regular text-compare tool to find differences (e.g. Beyond Compare, etc.)
0
dbbishopCommented:
Also, SQL Server 2008 does have an INFORMATION_SCHEMA schema with a number of views defined. Check system views in SSMS to see them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.