How can we integrate SQL Server Management Studio 2008 with TFS 2010?

Question

We want to maintain our sql server scripts history. What is the solution? can we integrate SQL Server Management Studio 2008 with TFS 2010?

Check if this is a duplicate-helpful: http://stackoverflow.com/questions/6815065/sql-management-studio-and-tfs — pantelif, Mar 28 '12 at 12:17

score 2 · Answer 1 · answered Mar 28 '12 at 16:02

2

Sure, there is, a DB professional which is a project type in the visual studio, this type of project will maintain DB objects as separate files so it can be treated as normal C# or VB file, for version control.

enter image description here

answered Mar 28 '12 at 16:02

Mohamed.Radwan -MVP

2,724
2
16
24

score 0 · Answer 2 · answered May 06 '13 at 10:08

SSMS is able to save sql files to SCCI compliant source control systems, such as TFS. Here is an article explaining how to achieve this.

However, this just saves sql files but doesn't assist in the versioning of the schema objects in your database. Should you need to do this, SQL Source Control, which we have developed at Red Gate, allows you to connect your SQL Server instance in SSMS to your back-end source control system, such as TFS.

score -1 · Answer 3 · answered Apr 30 '13 at 23:30

-1

How exactly does that integrate with SSMS??? You can still go behind the scenes with ssms and edit whatever you want, regardless of source control.

answered Apr 30 '13 at 23:30

george foreman

1

Please ask for clarification in question comments. Your answer in current form doesn't seem to be a solution. – Aleksei Zyrianov Apr 30 '13 at 23:57
Agreed. I suspect that George meant to comment on M.Radwan's answer. – David Atkinson May 06 '13 at 10:11

How can we integrate SQL Server Management Studio 2008 with TFS 2010?

3 Answers3