Visual Studio for Database Professionals Released

by Jonathan Allen on Dec 07, 2006 |

One of the fundamental differences between traditional application development and database development is that database development is not project based. All changes are applied to a live database, or if you are lucky, a development server. Application development, on the other hand, is usually isolated to the developer's machine.

Things are further complicated by the fact that in a database, the logic is intermingled with the data. This lack of a clear cut separation makes otherwise straightforward tasks like change management very difficult.

To address this, Microsoft has developed what they call "tools for building SQL databases in a managed project environment with support for versioning, deployment, unit testing, refactoring, and off-line SQL development." These tools, released under the name Visual Studio for Database Professionals, claim to offer a way to develop databases in the same off-line fashion as traditional applications.

Jeff Lynch posted his thoughts about the toolset, which he refers to as TeamData, back in October. Please keep in mind this was a beta, and it may have changed significantly since then.

I've found the single biggest change (paradigm shift) that "TeamData" enforces is working "off-line" in a "sandbox" environment rather than working on-line like you do using the Query Analyzer or SQL Management Studio. This "reality shift" can really take some getting used to and I suspect it will be the main issue for most developers at first. However, once you get used to the idea of NOT MUCKING AROUND with a live database (sorry for shouting) it really becomes second nature and provides a much greater sense of control during database development.

The second largest change is that "TeamData" provides the ability to unit test SQL user defined functions and stored procedures just like we can with our C# (or VB.NET) code. I believe this feature more than makes up for the lack of Intellisense in the SQL Editor since we can now test our code in a much more thorough and controlled manner.

Jeff Lynch also compares TeamData favorable to Red Gate's SQL Compare and SQL Data Compare. The Red Gate is considered he best developer of SQL Server tools on the market, so this is quite a complement.

Visual Studio for Database Professionals is available as a trial download or through a MSDN subscription.


Rate this Article


Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

General Feedback
Marketing and all content copyright © 2006-2016 C4Media Inc. hosted at Contegix, the best ISP we've ever worked with.
Privacy policy

We notice you're using an ad blocker

We understand why you use ad blockers. However to keep InfoQ free we need your support. InfoQ will not provide your data to third parties without individual opt-in consent. We only work with advertisers relevant to our readers. Please consider whitelisting us.