Tuesday, 5 July 2011

Comparing SQLServer schema -- using Visual Studio

This is so darned useful I just had to make a note to remind myself of it. One of the trickiest things to automate is database continuous integration. In many cases you want to check that a from-scratch deployment of your DB looks the same as a DB created by incrementally applying changes to some production DB. One way to do that is to do both, and compare schema. It turns out that Visual Studio can be of great help to you in doing that.

1 comment:

Chris Oldwood said...

For those of us cheapskates that can't afford the more expensive developer tools there is Open DBDiff and DBSourceTools on CodePlex.