SQL Server, source control and hands-off deployment of database changes

Question

Looking at and trying out several options for integrating all my sql database objects with source control.

I use subversion and red gate tools at my current job.

In the past I have used db ghost for scripting and building the db's out to a server.

Well, as it stands I am not happy with red gate and its integration with subversion, but the point of this post is to get some suggestions on where to go from here.

What I want to achieve is:

- have a local instance of a db that I apply changes to
- commit those changes into subversion
- build those changes against another database

Any suggestions?