13 มีนาคม 2555 15:04
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?
13 มีนาคม 2555 20:14เจ้าของ
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.
14 มีนาคม 2555 0:24
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.
15 มีนาคม 2555 2:52ผู้ดูแล
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.
27 กุมภาพันธ์ 2556 8:37
So is it still true that we cant use TFSPreview with SQL Management Studio for Source Control ?
28 กุมภาพันธ์ 2556 6:25
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.