After a lot of CTP versions the Visual Studio Team System 2008 Database Edition GDR RTM version has been released. The most important feature for me is the full support for SQL Server 2008. Use the database project to setup, generate, refactor, test, version, build and deploy your SQL Server 2008 database.
For a complete feature list, key architectural changes and installation instruction see Data Dude's blog post.
Download Microsoft Visual Studio Team System 2008 Database Edition GDR from Microsoft's Download Center.