Run, don’t walk, over to Channel9 and check out this awesome demonstration of all the capabilities of Visual Studio Team Edition for Database Professionals. Then click here to download the latest CTP which was released last week.
While database projects weren’t amazing in VS2003, I was extremely frustrated that they absolutely crippled the feature in VS2005. You can’t generate .dat files anymore, it doesn’t generate command files anymore and it generates schema files in a completely diff. fashion than 2003. Not cool at all. Luckily this new Team Edition for DBs really makes up for it 100x over… just wish it was released at the same time as the rest of VSTS.