SQL Server Management Studio 2016

[chipbeaulieu]

By default, SSMS 2016 does not support source control. However, MS posted an article to get it working with TFS at: https://blogs.technet.microsoft.com/dat ... udio-ssms/

By following the instructions including comments from users, I was able to get the Source Control option to show up in Tools > Options as in previous versions of SSMS. In the list of Source Control plug-ins, I see Vault Client. However, when I select this option, the list reverts back to the "None" selection. I also tried running SMSS as Administrator as well without success.

Has anyone had success in getting SSMS 2016 to work with Vault Standard?

[Beth]

Thanks for posting about this. I will get digging into this to find a work-around, and will post back if I find anything.

[stanyork]

FYI: I just installed SQL 2016 and its Management Studio and discovered the lack of source control support.

So, please count this as a "me too"

[stanyork]

This does not seem very promising; Microsoft also plans to remove support for Solution Explorer in a future release.

Refs:

• http://stackoverflow.com/questions/3774 ... ce-control
• https://msdn.microsoft.com/en-us/library/ms143729.aspx

[Beth]

I see people are finding ways to getting MSSCCI into SSMS 2016 in this thread: https://dba.stackexchange.com/questions ... ent-studio. We haven't tested this and can't offer support for it, but for those who need it, that post might get you started.

This request posted with Microsoft also suggests SSDT as the work around: https://connect.microsoft.com/SQLServer ... ls/2838424. Since integration with Visual Studio is both functional and fully supported, that might be the best route.

[Beth]

I found another post about ways to get source control back into SSMS 2016: https://blogs.technet.microsoft.com/dat ... udio-ssms/.

[c17]

Has anyone at all been able to get source control to appear and work in SSMS 17?

I've followed the instructions in the links in the posts above, but they do absolutely nothing.

Does SourceGear plan to address this major gap with an add-in?

Thanks,

C17

[Tonya]

Unfortunately, not much has changed. Back in 2016, Microsoft switched SQL Server Mgt Studio to use the Visual Studio Isolated Shell. In that release of SSMS, Microsoft removed all instances of source code control integration by dropping support for the Microsoft Source Code Control Integration (MSSCCI) API supported by their IDE.

At this time, Microsoft remains steadfast in not making changes to SSMS to add hooks nor support third party source code control integration. Users wanting an integrated experience can look to dbForge from devArt has a SQL Query tool that integrates with Vault. There is also integration with data bound projects within Visual Studio and there may also be limited integration with red-gate's SQL query tool.

Tonya