Visual Studio Team System 2008 Team Foundation Server MSSCCI Provider

Question

 

Released right before the holidays, the Visual Studio Team System 2008 Team Foundation Server MSSCCI Provider is available here. 

 

This version (2.0) includes:

• Updated provider to link against VS 2008 TFS assemblies (i.e. version 9.0.0.0)
  
• Enabled support for MSSCCI BeginBatch/EndBatch in VS 2003 and SQL Server Management Studio during Check In operations. This should alleviate the "multiple Check In dialog" issue by showing all pending changes in the workspace in the first dialog that appears and permitting the user to check in all changes from that first dialog.
  
• Changed Open From Source Control in VS 2003 to validate a project file exists in the selected server folder before leaving the dialog.

You can send feedback, bugs, and requests to [e-mail] or post to the Team Foundation Server Power Tools and Add ons forum.

 

Ed

Answer 1

I got the thing working in SQLServer management studio instantly; great!

However, I need it in VB6, too, because my customer wants me to migrate a VB6 solution to .Net.

It has been years ago since I started the VB6 IDE, but I cannot find any source control menu's. Even the good old Source Safe integration is missing. I cannot find source control plug-ins either in the Add-in manager. What are the steps to enable all this in VB6? I installed the TFS source control plug-in after VB6 SP6.

Answer 2

I found the solution!

 

Add the line:

 

vbscc=1

 

To c:\windows\vbaddin.ini

 

Then restart VB6, and you get a new menu item: Tools, Team Foundation

Answer 3

 

Hey Frans,

 

I have read ur message that u were successfully able to work with MSSCCI Provider in SQL Server Management Studio. Well, I have also installed MSSCCI Provider and trying to use it in SQL Server 2005. but I am not able to perform source control or i would say not able to configure source control for my databases.

 

What I have done till now :

 

I have installed Team Foundation Server MSCCI Provider

I have set the source control tool to Team Foundation Server MSSCCI Provider in the Tools-->Option Wizard.

 

What I want now :

 

I want to configure Team foundation Server MSSCCI Provider to use it with my databases so that i can checkin and checkout my database tables, procs, view, etc.....

I want to add my databases to the Source Control so that I can perform source control operations in the same manner as we do in .NET.

 

Like, when i right click on Database Name or on Table name or on Stored procedure it shows me the option to checkin or undo pending changes or checkout or Get Latest Version, etc....

 

So, Kindly please help me to get it done.

 Plzzzz

 

Answer 4

You have to create a solution file: File, New Project, SQL Server scripts.

Make sure you choose a destination directory that is inside your TFS workspace.

Add .sql scripts to the project as needed.

Right-click on your solution in the solution explorer and choose Add Solution To Source Control ...

Answer 5

Hi Frans,

 

I have installed Visual Studio 2008 on my System and Team System 2008 Foundation MSSCCI provider. Now using Visual Basic 6 with Service Pack 6, I can't see Tools->Team Foundation either (same problem as you were getting)

 

I looked at your solution where you mentioned to edit vbaddin.ini file.

 

But in my case i have Widows Vista on my system and i don't have this file in Windows directory and i also tried to create this file and placed into my windows directory but still no success.

 

Please anyone tell me if i could do something else to fix this problem on Windows Vista.

 

Regards,

Answer 6

Hi All,

 

I downloaded Visual Studio Team System 2008 Team Foundation Server MSSCCI Provider from MSDN and ran the msi file on my local machine as suggested. But i am not able to see any "Team Foundation" option in tools menu in VB6.

 

I have also installed SP6 for VB6 in my machine. I have Team explorer 2008.

I tried the same thing on the TFS Server as well. Installed VB6 with SP6 and installed the MSSCCI. \

i am able to see the Team foundation MSSCCI provider option in the Tools -> Option -> Source control options in SQL management studio.. but still not able to see the team foundation options in VB6..I have also made changes to the vbaddin.ini files.. it dint make a difference?

 

Kindly help as this is of high priority.

 

Thanks & Regards,

Sagar

Answer 7

"Enabled support for MSSCCI BeginBatch/EndBatch in VS 2003 and SQL Server Management Studio during Check In operations."

I'm a Visual Foxpro 9 SP2 user and I'm wondering if the BeginBatch/EndBatch functionality is exclusively for VS 2003 and SSMS? I'm using MSSCCI 2.0 and when I have multiple files checked out and I "select all" to check them in, I'm still prompted for each file by MSSCCI.
 
In VSS, I would "select all" and it would just give me one prompt for the whole batch of files.

Thanks.

Response from MS Support:

Hello,

Unfortunately current release of TFS Msscci Provider does not allow batching inside of Visual Fox Pro.

From my knowledge, VSS provider does not require BeginBatch/EndBatch because it does not show any dialog itself – the only visible dialog comes from VFP. Developing provider for TFS, we decided to show our own dialog during checkin, because this is the only way to specify work items and checkin notes.

We will investigate in future how to improve performance/usability of the TFS Mssci Provider inside VFP.

Thank you,

Michal Malecki

Answer 8

I just wanted to bump this thread back up to see if there has been any progress or new tips with regard to trying to add a project from VFP and check in a huge amount of files using the MSSCCI provider for TFS. It's not at all realistic to manually check in each file, one at a time, for a project that contains hundreds.

Any thoughts would be greatly appreciated.

P.S. We're using the latest provider beta for VS2010.

Update : I found a decent macro recorder to handle the repetitive clicking on checking in the long list of files.

Answer 9

Is using Team Explorer or the tf.exe command-line application a possible solution for you?

---

Ed Blankenship
Microsoft MVP (Team System, TFS, and ALM)

Answer 10

Hi all,

We are using  Visual Studio 6 for with  VC++. After binding to source control, .dsw and .dsp  files contain absolute server paths.

After the branch this path becomes obsolete and actually disables all source control- related activity (check out/in etc) as well as creates additional redundant mappings in workspace ( new separate mapping for every .dsw  being opened with Visual Studio 6) .

Any suggestions?

Answer 11

Thank you Frans! I've been looking for this for a while now!

Answer 12

Hello,

unfortunately this is limitation of Visual C 6. I would suggest manually fixing the path thought the script. After branch:

- sync branch workspace

- checkout all dsw and dsp files

- look for original server path and update it to branch server path

checkin

---

Michal Malecki TFS Version Control Client

Answer 13

Hi Ed,

will there be a Team Foundation Server MSSCCI Provider for 2010? I'm asking because we want to add Access databases into source control.

Regards,
Stefan

EDIT:

I found the answer in the Usenet: http://visualstudiogallery.msdn.microsoft.com/en-us/bce06506-be38-47a1-9f29-d3937d3d88d6

Answer 14

I had this same problem with VB6 and TFS2010.  This pointed me in the right direction, but note that for Windows 7 (and probably Vista) Users, the path to vbaddin.ini is different:

C:\Users\[userid]\AppData\Local\VirtualStore\Windows

The vbaddin.ini file in c:\Windows looked correct!  It wasn't until I added the line (which was missing) to the vbaddin.ini file in the above path that it finally worked!

Thanks for the tip.. almost 4 years later!

---

mp