Can you deploy/manage non-CLR procedures with VS 2010?

Is there a way to store just .sql versions of your stored procedures in a project, then deploy them automatically to a SQL server? Every article I find talks about using a SQL CLR project, writing them in C#, then deploying them, which I ca开发者_如何学Gon't do because my DBA won't enable CLR.

I am just looking for a way to add them to my solution so that they can be managed in svn, but not have to manually deploy them. Is that possible?

Visual Studio Premium Edition and upper allows you to create Database Project, store it under Source Control, Refactor and many other goodies..

Here is a great training on the subject by PluralSight:

http://www.pluralsight-training.net/microsoft/olt/Course/Toc.aspx?n=vs-db

And here is a blog post about it:

http://www.visualstudiotutor.com/2010/08/manage-database-projects-with-visual-studio-2010/