{"id":17765,"date":"2016-11-21T11:00:12","date_gmt":"2016-11-21T19:00:12","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=17765"},"modified":"2024-01-22T22:50:38","modified_gmt":"2024-01-23T06:50:38","slug":"source-control-in-sql-server-management-studio-ssms","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/21\/source-control-in-sql-server-management-studio-ssms\/","title":{"rendered":"Source Control in SQL Server Management Studio (SSMS)"},"content":{"rendered":"

This post was written by Ken Van Hyning, Engineering Manager, SQL Server Client Tools.<\/em><\/p>\n

In the latest generation of SQL Server Management Studio<\/a>, we moved to the Visual Studio 2015 Isolated Shell. While this provides SSMS a modern IDE foundation for many functional areas, it also had some consequences. Specifically, the integration with source control systems in SSMS no longer works the way it did in SSMS 2014 and prior.\u00a0 Previously, one could install the Visual Studio MSSCCI provider and then integrate with various source control systems. Visual Studio 2015 does not support MSSCCI so that is no longer an option to use in SSMS.<\/p>\n

Of course, the good news is that Visual Studio 2015 includes TFS and Git source control integration. With the move to VS 2015 Isolated Shell, SSMS should be able to use these packages as well, right? The answer is\u2026yes\u2026but! The issue for SSMS is that the TFS source control integration package VS provides also includes the entire suite of TFS integration features. If we include this package by default, SSMS will have Team Explorer in its entirety which includes things such as work item tracking, builds, etc. This doesn\u2019t fit in the overall experience SSMS is designed for, so we aren\u2019t going to include this package as part of SSMS. The full TFS integrated experience is included as part of SQL Server Data Tools which is designed for a more developer-centric set of scenarios.<\/p>\n

That said, if source code integration is an important aspect of how you use SSMS, you can enable the Visual Studio packages manually.<\/p>\n

Enabling source control integration in SSMS<\/h2>\n

To enable TFS integration in SSMS, follow these steps:<\/p>\n

    \n
  1. Close SSMS if it is running.<\/li>\n
  2. Install Visual Studio 2015 on your SSMS machine. If you don\u2019t already have Visual Studio, Community Edition will work fine. This is a large download but you can save some space by unselecting all languages during the Visual Studio install if your only purpose is to enable Source Control in SSMS.<\/li>\n
  3. Edit the ssms.pkgundef file found at C:\\Program Files (x86)\\Microsoft SQL Server\\130\\Tools\\Binn\\ManagementStudio\\ssms.pkgundef.\n