SQL Server 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

Hello Emy,

You could use the new SSDT = SQL Server Data Tools to create a Visual Studio for your existing database; the tool can import all objects of the db; see http://msdn.microsoft.com/en-us/data/tools.aspx

---

Olaf Helper

Blog Xing

Answer 2

Hi Emy,

I have found a similar thread:

http://stackoverflow.com/questions/187936/how-can-i-add-sql-server-database-objects-to-tfs

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.

Thanks,

---

Iric Wen
TechNet Community Support