SQL Source Control Creates a separate TFS "Workspace" for each Database
I recently implemented SQL Source Control across 35 different databases in our environment. It seems to be working correctly within SSMS (i.e. I see the 'green' databases, and checking in/out works great). We use Visual Studio Online, and generally, select TFS as the method for storage of our source control (vs git).
My process for adding each of the databases have been to right click on the database in SSMS, then select "Link Database to Source Control". Then I select "Link to my Source control system (TFS). Then "Choose your Source Control System = Team Foundation Server (TFS). Once at the "enter your source control locations", I create a new folder in our source control environment for the files to live in. I think 'link' the database and done.
That seems fine, however....
I recently noticed that when using Visual Studio to access my other TFS projects (i.e. source control for c# projects), that I have a large number of "workspaces" (I would wager somewhere in the neighborhood of 35).
The original workspace that I was using looks like it got named to "SQL Source Control (guid)", and I am not sure how best to work with the local workspace now.
1 - Is it normal to have a separate 'workspace' for each of my databases?
2 - when you commit your first SQL Source Control project to TFS, does it rename any existing worspaces? (or clone them or anything?)
3 - I want to follow best practices for working with these many workspaces. I don't mind having a bunch of them around, if that enables the software to work. I just need to know how to work with my other worskpaces in this now shared space.
I am happy to screenshare (I have https://join.me/joshmiller that I can spin up at any time.)
I would appreciate an expert opinion on this.