Visual Studio for Data

Jun 07, 2006 • 2 minutes to read

I know I’m way late on this one, but it’s a great one, and that’s the announcement of Visual Studio Team Edition for Database Professionals. One of the coolest things about Microsoft is seeing all the interesting projects that are coming and actually being able to both beta test and provide input to them at a really early stage. Back in February of 2005, I made a post about “My Dream SQL Tool Features” with a wish list of features that I wish our tools had including:

  • DTS support for Importing XML
  • Data Validation Rules
  • Unit Test Support
  • Refactoring
  • FxCop
  • Source Control for Stored Procs, Views, Triggers, Functions

I of course passed this onto the Data Dude team (internal name for the SKU and the persona behind VS for DBs) as they were just starting to staff the team. The good news is that Unit tests, rename refactoring, and Source control are all in the TechEd CTP (XML import in DTS is in SQL 2005). Another great feature that I didn’t have on my list (but really should have) is dummy data generation

You may already own this product: Do you own Visual Studio Team Suite? If so, this upgrade is **free **

For more info, check out blogs from the team:

Justice 2.0 - How not to steal a Sidekick

RSS Screensaver Mod using Windows RSS Platform