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

 

8 Comments

  • Will there be any kind of build-in IntelliSense for SQL?

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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

Comments have been disabled for this content.