3rd party you have Toad which was named best of Tech Ed as far as IDE's go. It has quite a bit of management technology plus a log reader...

Sorry, probably not a good fit in your env where there's no 1:1 relationship...as far as the Compare/Synch GUI in Toad is concerned.

Check out Toad for SQL Server (not the freeware edition). It has a Data compare and synch feature that allows you to do synchs in either direction. Data...