Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

People also ask

Does SSMS have a SQL Formatter?

Format SQL code using SSMS optionsSSMS provides a couple of options to format SQL code. Those options are indenting, tab sizing, make all code in upper or lower case, comment/uncomment selected code, etc.

Do I need to install SQL Server for SSMS?

Conclusion. As we can see it is possible to install only SQL Server Management Studio on a local machine (without installing the SQL Server database engine and its other components) and connect using SSMS to a remote SQL Server instance.

Is SSMS backward compatible?

Regardless of the edition being used, SQL Server Management Studio only comes in one flavor and boasts backwards compatibility with almost all features from versions 2008 to 2019, including SQL Azure support.


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

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

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


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".


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.