Poor Man's T-SQL Formatter #Download #Install

Download

Ready-to-run:

• Extension for CURRENT VERSIONS of Visual Studio (2015-2019) (VSIX Package): Download from the Visual Studio Marketplace: https://marketplace.visualstudio.com/items?itemName=TaoKlerks.PoorMansT-SqlFormatterSSMSVSExtension

 

• Extension for CURRENT VERSIONS of SSMS (2014-18) (setup program): PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16.msi (52427 downloads for this version, about 20,000 for previous versions).

 

• Visual Studio Code extension: On the Visual Studio Marketplace: https://marketplace.visualstudio.com/items?itemName=TaoKlerks.poor-mans-t-sql-formatter-vscode

 

• Atom Editor plugin: In the Atom Package Manager: https://atom.io/packages/poor-mans-t-sql-formatter

 

• Notepad++ plugin: It's recommended to use the Notepad++ plugin manager if available (Notepad++ is an amazing free GPL-licensed text editor, available at notepad-plus-plus.org; it has a very rich plugin community available. Historically this was accessed through the "Plugin Manager" plugin, but this is no longer installed by default. The new Plugin -> Admin feature doesn't yet support Poor Man's T-SQL Formatter, but should soon).
  • If you need to install the plugin manually, you can get it from here: SqlFormatterNppPlugin.1.6.13.zip (11772 downloads for the latest version, about 410000 for previous versions).
    • For Notepad++ 7.5.9 and earlier, unzip the entire contents of the ZIP file (1 DLL + 1 folder containing other DLLs and stuff) into your Notepad++ install folder's "plugins" subfolder, eg "C:\Program Files\Notepad++\plugins".
    • For Notepad++ 7.6 to 7.6.2, upgrade. These versions had inconsistent plugin-loading folders (flip-flopping all over the place).
    • For Notepad++ 7.6.3 and later, if properly installed via installer, create a new folder called "PoorMansTSqlFormatterNppPlugin" in your Notepad++ install folder's "plugins" subfolder, eg "C:\Program Files\Notepad++\plugins\PoorMansTSqlFormatterNppPlugin", and unzip the entire contents of the ZIP file (1 DLL + 1 folder containing other DLLs and stuff) into this new subfolder. It's almost the same as before 7.6, except now the contents of the ZIP file ned to be in a correctly-named subfolder, not directly in the plugins folder.
      • If you've got a "portable" Notepad++ setup, then the old approach (unzip the entire contents of the ZIP file (1 DLL + 1 folder containing other DLLs and stuff) into your Notepad++ install folder's "plugins" subfolder) should still be the right thing.
    • If you get an error about the plugin not supporting unicode, then the wrong DLL is in the plugins folder, simply delete the incorrect DLLs and start again (please contact me for help if you have any issues with this).
  • 64-bit version : SqlFormatterNppPlugin.x64.1.6.13.zip (8189 downloads for the latest version, about 4350 for previous versions)

 

• Extension for Visual Studio 2013 (VSIX Package): Download from the Visual Studio Marketplace: https://marketplace.visualstudio.com/items?itemName=TaoKlerks.PoorMansT-SqlFormatterSSMSVSExtension2013

 

• Add-In for OLD VERSIONS of SSMS (2005-2012) and Visual Studio (2005-2012) (setup program): PoorMansTSqlFormatterSSMSAddIn.Setup.1.6.10.msi (7786 downloads for this version, about 130000 for previous versions).

 

• WinForms App (simple exe): SqlFormatterWinforms.1.6.13.zip (3685 downloads this version, about 32000 for previous versions)

 

• Command-line bulk formatting utility
  • Windows / .Net exe file: SqlFormatter.1.6.10.zip (7170 downloads for this version, about 14000 for previous versions)
  • Linux (and others) node-based commandline tool: Installable via npm - https://www.npmjs.com/package/poor-mans-t-sql-formatter-cli

 

• WinMerge Plugin for SQL Script comparison (setup program): PoorMansTSqlFormatterWinMergePlugin.Setup.1.5.1.msi (2193 downloads for this version, about 2000 for previous versions) (WinMerge is a free GPL-licensed file comparison tool, available at winmerge.org)

Compiled Library to use in other GPL/AGPL projects or internal non-distributed projects:

• SqlFormatterLibrary.1.6.13.zip - .Net 2.0 version (196 downloads for this version, about 1200 for previous versions)
• SqlFormatterLibrary35.1.6.13.zip - .Net 3.5 and later version (1106 downloads for this version, about 1700 for previous versions)
• (there's also a NuGet package, kindly set up and maintained by Adam Pawsey - but now quite outdated)

JS Library to use in other GPL/AGPL projects or internal non-distributed projects:

• NPM library: https://www.npmjs.com/package/poor-mans-t-sql-formatter

Source:

• Please download from github at https://github.com/TaoK/PoorMansTSqlFormatter. If this is impractical for whatever reason please contact me, and I'll make the source available by some other mechanism.

 

출처: http://architectshack.com/PoorMansTSqlFormatter.ashx#Download_5

Poor Man's T-SQL Formatter - Architect Shack