Some notes on Team Edition for Database Professionals
I've been doing presenations, webcasts and training events on Visual Studio 2005 Team Edition for Database Professionals recently. This blog captures a few of the more interesting questions and the answers to them - at least as much as I can give based on CTP5.
- Does this tool seem a little slow to you?
First off, this is a prerelease and you have to expect it to be less performant. That said, make sure you're using CTP 5 and then install the patch from http://www.microsoft.com/downloads/details.aspx?FamilyID=9f7d1be0-79c0-4d26-81e2-4ccd07d2352f to improve the performance.
- Can I reverse engineer Encrypted Stored Procedures in SQL 2005?
I don't have the final definitive answer on this but all indications are 'no'. I will probably try a few more tests but I don't expect this answer to change.
- Does it capture non-relational objects such as SQL Server Reporting Services reports or SQL Server Integration Services packages?
In my opinion, both of those types of objects already have Visual Studio project templates and designers. They can already be captured in version control and are part of a richer environment in themselves than you'd see in DB Pro. So this isn't an answer, but in my opinion most people will want to manage them in the native design environments.
- Where can I get it? (Ok - I invented this one but it makes sense)
The software is (as of this writing) available in pre-release only. It will be part of Visual Studio 2005 Team Suite, so those of you who are using that have a decent chance of getting this when it is released! It is expected to release later this year and will be purchasable separately at that point.
Assuming you want it now!!!! You can download the current community technology preview (CTP5) from http://www.microsoft.com/downloads/details.aspx?FamilyID=4014554e-903a-4a62-b429-2b027321c32d.
- Is there any more information? (Ok - another contrived question just to keep you going...)
The product website on MSDN (http://msdn.microsoft.com/vstudio/teamsystem/dbpro) is a great resource will links to webcasts, blogs, the forums and most of the other links I mentioned above.