Does the Poor Man's T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2016?

Question

Basically the same question as this but now for SSMS 2016.

I've installed SSMS 2016 RC3 (alongside SSMS2012 & SSMS2014). I also installed Poor Man's formatter and copied the 11.0 folder as 12.0 and 13.0. When launching SSMS2014 I have the Tools > Format T-SQL Code menu-option. Which I don't have in SSMS106. Am I overlooking something?

score 3 · Answer 1 · edited Apr 13 '17 at 12:42

3

Since RC2, they've moved to using Visual Studio 2015 shell for it. Plugin authors will need to update their plugins to support the newer APIs. - https://dba.stackexchange.com/a/134208

Also, take a look at ApexSQL Refactor. It's free and supports code-formatting as well. ~~At this time of writing, it currently doesn't work with SSMS2016 RC2 and above though~~. It also now supports SSMS 2016.

edited Apr 13 '17 at 12:42

Community

1
1

answered May 02 '16 at 03:31

Dealdiane

3,984
1
24
35

ApexSQL Refactor looks good on first glance, but surprised me by taking over the Ctrl-Shift-B keyboard shortcut that I constantly use to rebuild the solution. – Michael12345 Feb 15 '17 at 23:44
Just curious, what do you build in SSMS? – Dealdiane Feb 16 '17 at 00:03
My apologies. I've installed ApexSQL into both SSMS 2016 and Visual Studio 2015, and I struck the Ctrl-Shift-B issue in Visual Studio. – Michael12345 Feb 16 '17 at 07:40

score 2 · Answer 2 · answered Oct 17 '17 at 21:46

2

This support was finally added today. Download the new SSMS Extension at http://architectshack.com/PoorMansTSqlFormatter.ashx

answered Oct 17 '17 at 21:46

Tao

13,457
7
65
76

Thanks! I'll have a try with it – MarcS Oct 19 '17 at 05:54

Does the Poor Man's T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2016?

2 Answers2

Linked