Managing Database Schema Changes with Visual Studio Team System - Database Edition

Here is MSDN's article on managing database schema changes using Visual Studio Team System - Database Edition. In short, VSTS adds 'Database Project' projects templates. You get 'SQL Server 2000' and 'SQL Server 2005' templates. (These are similar to the more familar project templates like C# 'Windows Forms Application'.) Using source control, you can now use this project to track your schema and changes to it over time. You can compare versions, build deployment scripts and so on.