18 October 2006

Visual Studio Team Edition for DB Pros

Visual Studio Team Edition for DB Pros CTP6 is now available. Check out Cameron's post for the full details. Here is an excerpt of what's new since CTP5:

  • Full SQL Server 2000 & 2005 object support
  • Extended Properties Support
  • Inline constraint support
  • Pre and Post script deployment population during Import Script
  • Team Build Support
  • Import Schema Wizard ( also integrated with the New Project Wizard )
  • The ability to synchronize your project from a database ( selective import essentially, based on differences. We heard your feedback! )
  • Refactoring is allowed in files that are in a warning state
  • Overall stability and performance
  • Fixed many customer reported problems
  • Support for 3 and 4 part name resolution when referenced database is present on design instance
  • No longer install SQL Express ( you'll notice the download is a LOT smaller! ). You can pick your own SQL Server 2005 Developer Edition or SQL Server 2005 Enterprise Edition instance on the local box
  • Display detailed Schema Object properties in the property window for selected objects in the Schema View
  • Separation of user target database settings through the user project file

Having support for Team Build should be a definite plus when it comes to versioning a database with an application release. I look forward to playing around with that feature.