Programming Analytics

A feed of interesting tidbits from IT, software engineering, business intelligence, and videogaming.

I’ve really missed my old Red Gate SQL Compare product - I’ve been using it for years and it was a fantastic tool. But for working on independent projects, I just didn’t want to pay for a personal use license. So that’s why I’m excited to find this project:

http://code.google.com/p/sql-dbdiff/

Despite the awkward user interface, this program does appear to get a thorough database schema from a Microsoft SQL server, and it appears to be fully capable of doing a difference analysis and creating a changescript. With a bit of cleanup, this program would be a fantastic replacement!

As a note, it looks like it’s a fork of this program:

http://opendbiff.codeplex.com/

I’ll need to do some more analysis to figure out which one is a more appealing start. However, they both appear to have ended development sometime in 2010 - I wonder why?