ApexSQL Diff
I first heard about this tool from my friend Greg at work. I’ve been using it the past couple of weeks now as a free trial and it’s awesome. Compare the structure and/or data of any two databases and synchronize them with just a few mouse clicks.
This tool is perfect for deploying database changes to different environments. It’s already saved me hours of time compared to what I would have spent trying to do things manually. I’ll definitely be buying a copy for myself. Every DBA should own a copy.