The Visual Studio Team Edition for Database Professionals RTM bits are available for download!
MSDN subscribers can find the bits by looking at their available subscription downloads. MSDN provides the full image download of the standalone SKU which is 2.9GB in size (this contains Visual Studio 2005 Pro, MSDN and the Visual Studio Team Edition for Database Professionals add-on).
For existing users of Visual Studio 2005 Team Suite (full or trial) there is a separate much smaller add-on you can install. There is a self extracting EXE of just 7.8 MB and a 19.2 MB ISO image if you want to burn a CD. Check out the following download location.