VS 2005 Team Edition for Database Professionals

At TechEd this week Microsoft is going to be showing off the new VS 2005 Team Edition for Database Professional tool which is now part of the Visual Studio Team System line of products.  You can learn more about it here.  The first CTP build will be available to MSDN subscribers on June 11th. 

It provides a number of pretty cool features including:

  • Integrated source code control for database schema, scripts and sprocs
  • Refactoring support in the database (allowing you to change objects and have everything update)
  • Automated unit test support for SPROCs, T-SQL, etc
  • T-SQL code editor support (including support for viewing execution plans)
  • Schema and data compare support for quickly comparing databases
  • Data generators for loading up databases with pre-populated test data

All the above features are also now integrated within the Visual Studio IDE, and can be used with the team collaboration features of Visual Studio Team System.  Learn more about them all here.

Hope this helps,

Scott

 

Published Friday, June 09, 2006 2:22 PM by ScottGu
Filed under: , ,

Comments

# Link Listing - June 10, 2006

Saturday, June 10, 2006 11:13 PM by Christopher Steen

 **NOW AVAILABLE** MOSS ECM Starter Kit for B2 (white
 papers, code samples, workflows, and VS...

# re: VS 2005 Team Edition for Database Professionals

Monday, June 12, 2006 8:58 AM by Vladimir Bychkov
Will there be any kind of build-in IntelliSense for SQL?

# re: VS 2005 Team Edition for Database Professionals

Monday, June 12, 2006 10:56 AM by Stephen Redd
Will the new database project and TSQL editor make it into the Team Edition for Developers or other versions of VS?

The database project and server explorer's database tools suffered terminal neglect between the VS 2003 and 2005 releases... I was especially disappointed by the script generation support. In general server explorer and the DB project is much less functional for DB management/dev than it was in 2003. I am hopeful that the improvements Team Edition for DB Pros brings to these areas will be available to all, not just those that upgrade to team suite.

# re: VS 2005 Team Edition for Database Professionals

Monday, June 12, 2006 11:38 AM by Curtis
Why oh why are there so many editions depending on your job function?  It complicates licensing, and organizations that have people with multiple 'hats' (like mine).

Should just be one 'Team' product for all, with plug-ins for the different modules.  Why buy a whole new VS just for this ADD-ON?

ugh.

# re: VS 2005 Team Edition for Database Professionals

Tuesday, June 13, 2006 8:46 AM by Josh Gough
This looks pretty interesting. I have been using Red Gate for almost four years with great success, but I don't think it can create test data or unit tests. It has saved so much time though.

# re: VS 2005 Team Edition for Database Professionals

Tuesday, June 13, 2006 1:59 PM by Ryan
This is great, however how can we have this functionality with Regular Developers?

We have an 8 developer team, all who manage the Databases. It would seem silly to only have 1 version manage the Stored procedures... we have over 400 stored procedures in our one application.

I do hope we can get this functionality for Software Developers.

# re: VS 2005 Team Edition for Database Professionals

Tuesday, June 13, 2006 10:37 PM by Jeff
I totally agree with Curtis. I work for a small company with only 3 developers and we all have to deal with database, ASP, VB, etc. It's a shame that we need to distinguish the products in such a fasion.

# re: VS 2005 Team Edition for Database Professionals

Monday, July 03, 2006 5:56 PM by Bruce W Cassidy

Is there any vague timeline on when this product will be released?

Also, would you be comfortable with us starting to use this in the development environment?  Or should we plan to wait for Beta 2?

Thanks.

# re: VS 2005 Team Edition for Database Professionals

Monday, July 03, 2006 10:04 PM by ScottGu

Hi Bruce,

Unfortunately I'm not 100% sure of the release timeframe.  But if you check out the forum for it on http://forums.msdn.com they should be able to help you out.

Hope this helps,

Scott