We’re very happy to announce the first public CTP of Service Release for the recently launched Visual Studio 2005 Team Edition for Database Professionals. This Service Release addresses issues that were found through a combination of customer or partners feedback, as well as internal testing. The issues addressed range in severity from losing extended properties when writing to project from within Schema Compare to generating too many warnings when referencing objects in other databases.


We have added a number of key functionality to this service release which we would like to get your feedback on(the good, bad and the uglyJ)

·          Customer Reported Issues

o       Cross Database Reference which allows you to reference other objects in different databases by using database project references or referencing a database metafile(.dbmeta) therefore eliminating the cross database reference warnings within your database project.

o       Greater File support within Filegroups which allows you to define the files within file groups as Database Project properties as opposed to establishing the file within the pre-deployment storage script

o       Variables – We’ve added a variables page to the Database Properties pages to allow you to define setvar variables for their deployment scripts

·          Microsoft SQL Server 2005 SP2 – The Service Release supports the latest Service pack release from Microsoft SQL Server 2005

·          Microsoft Windows Vista – This Service Release supports the Microsoft Window Vista operating system



Important Notes:

  • This service release will upgrade your project file (.dbproj) when you first open your project after installing the service release. It will create a backup copy first.
  • This CTP can be applied to both the retail and the trail edition of Visual Studio Team Edition for Database Professionals.
  • Since the service release is patch installer, you need to have the RTM version installed.
    • If you have the hotfix installed (KB933015), you do not have to do anything, just install the this patch
    • If you were one of the lucky ones that was asked to test drive the private CTP of this service release, you have to uninstall that one first.
  • The installer does require that Visual Studio 2005 SP1 has been installed first
  • This CTP only supports the English version of Visual Studio Team Edition for Database Professionals; the final release will support all 9 languages.

Where can I get this:

You can provide feedback through our MSDN forum or through Microsoft Connect.