This is hardly breaking news for all those who are in fact, Database Professionals, but it was worth noting that this has finally been released. I'm not actively using this version of VSTS but the DB architect on my project simply rants and raves over how great this new tool is.
In my opinion, the coolest feature is the ability to do schema compares and data compares. I've always thought that these types of synchronization tools were extremely important for several reasons:
- It ensures that all of the staging environments are running off of the same database schema.
- It allows easy deployment promotions to Staging, QA, and Production servers. Its really easy to ignore individual changes made between deployments since it is now easy to run a comparison and generate a single large change script.
- It is a helpful tool for troubleshoot vague data access issues.
Here is a screenshot of the new VSTS Database Pro Edition using Schema Compare.
