PoorMansTSqlFormatter icon indicating copy to clipboard operation
PoorMansTSqlFormatter copied to clipboard

Add VisualStudio 2022 Package

Open lennybacon opened this issue 4 years ago • 9 comments

I created a working version for VisualStudio 2022.

  1. Changed Solution for VisualStudio 2022.
  2. Changed Target Frameworks to .NET 4.8
  3. Added VS2022Lib which references VisualStudio 2022 extensibility assemblies.
  4. Added Package for VisualStudio 2022.
  5. Had to fix the version numbers of the references projects.

Open Questions:

  • For 3) The files might be linked from the SSMSLib project.
  • I would like to omit 5. I have no Idea of the build process or how versions are set

Looking forward hearing from you!

lennybacon avatar Jan 05 '22 23:01 lennybacon

Bump!

gbny avatar Feb 03 '22 07:02 gbny

It's really too bad this project appears to be abandoned. Thank you @lennybacon for updating this package; I'm installing it in my dev system because I use PoorSQL all the time. In fact, I train everyone that works for me that it's a requirement to run all SQL code through it (with certain settings) before checkin. So having it as a package is GREAT.

crazycga avatar May 23 '22 20:05 crazycga

Yes, thank you @lennybacon for the update. It's much appreciated. Our team has also installed it in VS 2022 from your fork.

@TaoK It would be great if you could accept the pull request and get it into the marketplace, but I understand that open source can be thankless work. Either way, thanks for the effort you've put into it. This really is an excellent SQL formatter.

Da13Harris avatar May 25 '22 23:05 Da13Harris

I'd really like to use this but I have no experience installing VS plugins from source. Can anyone help with a list of steps to get this working in my IDE?

Grendagon avatar Jul 15 '22 08:07 Grendagon

@Grendagon

  • Just download the sources.
  • Install Visual Studio 2022
  • Open the Project
  • Compile the sources ([CTRL]+[SHIFT]+[B])
  • Find the *.vsix in the output folder.
  • Double click the *.vsix to install

lennybacon avatar Jul 17 '22 12:07 lennybacon

I have thrown up the port onto marketplace - https://marketplace.visualstudio.com/items?itemName=mick9956.PoorMansTSqlFormatter

mj6robinson avatar Dec 20 '22 05:12 mj6robinson

@mj6robinson thank you. A merge would be even better but this will allow to just install and use it.

lennybacon avatar Dec 20 '22 11:12 lennybacon

+1

mpsoftdev avatar Sep 29 '23 18:09 mpsoftdev

My path to a working install for SSMS 20 was: 2. Deinstall [sic] the Microsoft C++ 2015-2022 Redistributable and also Microsoft C++ 2015 Redistributable 3. Install PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16.msi 4. Install Microsoft Visual Studio 2015 Shell (Isolated) (found [vs_isoshell.exe] in the Visual Studio 2015 SDK. The cat file on the official MS VS website doesn't work) 5. Copy the PKGDEF File to "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions\PoorMansTSqlFormatterSSMSPackage.pkgdef"

GerritKViehmannHE avatar Jun 18 '24 10:06 GerritKViehmannHE