Setting Data Compare Options in VSTS for Database Professionals (DataDude)
Changing the comparison rules for the Data Compare is not as obvious as it should be. You need to go into the Tools -> Options menu to make changes.
- Click on the Tools Menu -> Options
- Expand Database Tools in the tree
- Select Data Compare.
I'm waiting to see if this has changed in v1.0, but I'd suggest that a button is added to the default Data Compare toolbar.
The same problem exists for Setting Schema Compare Options in VSTS for Database Professionals (DataDude).