56

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn't.

I tried to run the installer again, and it gave me options to repair or uninstall. I had the formatter installed prior to installing 2014.

EDIT: The tool is available here.

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
Hoppe
  • 6,508
  • 17
  • 60
  • 114

5 Answers5

130

Create the folder 

%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\

if it does not exist. Then just copy the file from:

%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn

to

%SystemDrive%\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\PoorMansTSqlFormatterSSMSAddIn.AddIn
War10ck
  • 12,387
  • 7
  • 41
  • 54
alialtansaka
  • 1,316
  • 1
  • 8
  • 2
  • 5
    Confirmed that this also works with SQL 2016 CTP. You just need to add the folder as "13.0". – Loki70 Dec 21 '15 at 17:43
  • This works, just make sure to follow path names exactly. I now get a Format Sql menu under Tools. – live-love Feb 08 '16 at 16:26
  • 3
    Seems to be broken in the latest 2016 version with updated visual studio shell running in isolated mode. Anyone get it to work. – betelgeuce Jun 02 '16 at 11:05
  • 3
    I guess issue is that SSMS 2016 no longer supports addings, everything is a extension now. Code needs to be updated to support SSMS 2016 and upwards. – Evaldas Buinauskas Jul 27 '16 at 08:31
  • 1
    For SSMS 2017 Adding folder 14.0 and copying the add-in doesn't work for me – dfmetro Oct 04 '17 at 14:26
  • Support added for SSMS 2014 (official / no hack required), 2016 and 17. Download at: http://architectshack.com/PoorMansTSqlFormatter.ashx – Tao Oct 17 '17 at 21:41
21

UPDATE: more than three years later, this support has finally been added.

Download page is still http://architectshack.com/PoorMansTSqlFormatter.ashx for now.

Tao
  • 13,457
  • 7
  • 65
  • 76
  • 7
    Your tool is awesome. Please do let me know when it's updated! – Hoppe Apr 30 '14 at 22:34
  • 2
    Note: this is open source so if you have the time to make the simple change you can contribute. Would be nice for 2016 as well. http://architectshack.com/PoorMansTSqlFormatter.ashx#Contributing_11 – Karl Kieninger Jul 22 '15 at 12:55
  • 1
    FYI - Currently trying to get this working in SSMS 17.1... hold my beer. – CaptainMarvel Jul 05 '17 at 19:23
  • 1
    @CaptainMarvel sorry about the wait, this is finally done (including SSMS 17) - download in the usual place. – Tao Oct 17 '17 at 21:42
  • 1
    When I execute PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16.msi for SSMS v18.1 then I do not see PoorMansTSqlFormatterSSMSAddIn.dll anywhere in my system.I copy this dll from another system .Do dll version matter ? Why dll not getting downloaded. – KumarHarsh Jan 02 '20 at 04:12
  • 1
    There seems to be an issue for SSMS 18.8, one suggestion [on youTube](https://youtu.be/jcAsmND1C2I) suggested installing VS Isolated Shell which works. The msi installer places the pkgdef file under ```C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Extensions``` could it just be missing an *extension.vsixmanifest* file? (as another similar extension has w/o needing the Iso Shell) – yeOldeDataSmythe Mar 03 '21 at 21:15
7

With the permission of the PoorMans Formatter developer we have integrated it in our add-in "SSMSBoost". Recent version of SSMSBoost supports SSMS 2014, so you can use it to use Poor Man's formatter features. We have already developerd our own formatting engine, but have left "Poor Man's formatter" for backward compatibility, for those users, used to it. You will find it in formatter-styles drop-down as "Old fashioned formatting style".

Andrei Rantsevich
  • 2,879
  • 20
  • 25
  • I switched to using this plugin because the poor man's SQL formatter hasn't updated it's code base to work with 2014 – Hoppe Jul 16 '15 at 19:21
  • Tried this, but could not find a way to format the sql code, no menu option. – live-love Feb 08 '16 at 16:28
  • After installing SSMSBoost, you see it's toolbar. It contains "Format SQL" button. Near this button there is a drop-down where you can choose formatting engine and templates. If you have problems - write us to support@ssmsboost email – Andrei Rantsevich Feb 26 '16 at 12:01
  • This tool has it all - I'm very impressed. admitally; I haven't seen the price yet. – Christian Jul 28 '21 at 05:56
2

No, it has not been updated yet.

As of 2014-04-25 the most recent built is from 2013-10-23, version 1.5.3.

http://architectshack.com/PoorMansTSqlFormatter.ashx#Latest_Changes_6

Edit:

Since I hadn't installed the plug-in on my new machine with 2014 I went a head and tried. It does not work on my fresh install, but does still on the side-by-side 2012.

Karl Kieninger
  • 8,841
  • 2
  • 33
  • 49
0

With SSMS 18.10 I successfully got Poor Man's T-SQL Formatter working applying the proposed fix from https://github.com/TaoK/PoorMansTSqlFormatter/issues/234#issuecomment-1264508689

Add the following (missing) tags to C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe.config

    <dependentAssembly>
        <assemblyIdentity name="Microsoft.VisualStudio.Shell.12.0" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="2.0.0.0-14.0.0.0" newVersion="15.0.0.0" />
    </dependentAssembly>
McLoo
  • 13
  • 4