How can I add SQL Server database objects to TFS?

Question

We don't currently have our SQL Server objects in any form of source control. We recently installed TFS 2008 and I'd like to get our SQL server code added. I think I could script all of the database and create script files for each object, but I'm hoping there is a way to point to a database in SSMS and create a project that can be added to TFS or something similar. Basically, I'm look for the simplest way to get from point A to point B. I've installed the TFS MSSCCI Provider and I see TFS in the source control provider options in SSMS. The SQL Server instance is SS2005.

Answer 1

If you have a visual studio Team Developer license you can download the Database edition. It has a project type that can bring your tables, sprocs, triggers, etc under source control and check it into TFS.

update:
Redgate has a product called SQL Source Control. Which ties back into several source control systems like TFS, SVN, etc.

Answer 2

You could also try ApexSQL Version, a SSMS add-in for versioning databases and db objects directly in SSMS.

We're in the process of constant improvement and you can also see our roadmap for future improvements in this article: Redesigning ApexSQL Version – The road map

Disclaimer: I work for ApexSQL

Hope this helps

Answer 3

I think generating your own scripts is the best way to do it, as described in this excellent series of articles:

http://odetocode.com/Blogs/scott/archive/2008/01/31/11710.aspx