Management Studios does not have the ability to sync databases for you. You can do a stare-and-compare by visually examining 2 different DBs, but it will not do the comparision for you, generate a delta report, and do any schema or data syncing.
There is software packages out there that do, like RedGate's SQL Compare. You could also create a full schema script for each DB and compare them in a text compare tool like Beyond Compare. You'll then be responsible for creating the DDL necessary to sync the schemas. RedGate's SQL Compare will do all of that for you.
John Rowan
======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden