Archive for June, 2007

Can Database Development be Agile?

June 30, 2007

I’ve been a big advocate for Microsoft’s new Visual Studio Team System product line.

The initial launch was in 2005 and was marketed as a Dev Tools suite for Architects, Developers, Project Managers, Testers and "everyone else".

Unfortunately the "everyone else" did not include DB Developers.

The good news is that the newest member of the VSTS Suite is called Visual Studio 2005 Team Edition for Database Professionals. It was launched in December 2006.

The bad news is that it only works with SQL Server 2005. It looks like support for ORacle is coming but don’t hold your breath.

In any case, this tool provides the ability to incorporate a daily Database build into the regular daily build.

Finally the DB team and the App dev teams can collaborate and not "hate" each other.

Now when we say the "truth" is in version control it also includes the Database.

More info is here.