BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

Visual Studio for Database Professionals Released

| by Jonathan Allen on Dec 07, 2006. Estimated reading time: 1 minute |

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

Adoption Stage
Style

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

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and dont miss out on content that matters to you

BT