Connect to tfspreview from SQL Server Management Studio

Question

Hi!

I would like to connect to tfspreview from SQL Server Management Studio, so I can add my database scripts to source control. I found the "Team Foundation Server MSSCCI Provider 2010 32-bit" but when I install this, I can't login into tfspreview. Is there another way to connect to tfspreview from SQL Server?

Answer 1

sorry to hear that you are experiencing this issue but there is no way to connect to TFS Azure datatier and this by design. This is to make it easy for customer to get started with TFS without any maintainance or worrrig about database. With this approach we release new updates very often and can maintain all databases at same level at the same time we don't have any access to your data.

Answer 2

Mloun,

If the intent is to version control your database scripts you can resort to creating a sql server database project, with the wizard you can also opt to create the schema/scripts from an existing Sql database project as well. http://msdn.microsoft.com/en-us/library/ff678491.aspx

---

Please remember to mark the replies as answers if they help.

Blog: http://geekswithblogs.net/TarunArora  Subscribe in a reader

Answer 3

Tarun__Arora +1

Mloun,

The team foundation server MSSCCI Provider 2010 was designed for some applications which do not support Team Explorer integration. However, to connect to tfspreview, we need to install a new credential provider which only support team explorer(at least for now).

I suggest you submit your idea(update the MSSCCI provider to support tfspreview) to http://visualstudio.uservoice.com/forums/121579-visual-studio

For now, please follow Tarun's suggestion.

Thanks for your understanding and cooperation.

---

Alan Yao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

Hi ,

So is it still true that we cant use TFSPreview with SQL Management Studio for Source Control ?

cheers,

Andy.

Answer 5

Hi Andy.

I think it is possible. Here are the steps (I am assuming that you have already installed MSSCCI Provider 32-bit)

1. Create an account at tfs.visualstudio.com (free)

2.Creating an empty project at MySelectedNameDuringRegistration.visualstudio.com (the first part of the URL is given during the registration (Step 1)

3. Add  MySelectedNameDuringRegistration.visualstudio.com  as your Source Control server in SSMS

4. Create a new project in SSMS (File/New/Project) - don't forget to check 'Add to Source Control' right above the OK button at the bottom

5. Login if required and select the empty project created earlier (Step 2)

That's it - you have enabled source control for your project.

Please let me know if you need more details.

Thanks,

---

Varsham Papikian, New England SQL Server User Group Executive Board, USA
New England SQL Server User Group; My LinkedIn page
Please remember to click the "Mark as Answer" button if a post helps you!