Visual Studio External Tool DataGrip Format Command
I want to run the Format command on SQL files in Visual Studio (2019). If I understand correctly, I can call the format.bat file in the Bin folder under the install directory passing in the file. I try that via Command Line and like magic, it works!
I then setup the External Tools command in Visual Studio as such:

When I have a file open in Visual Studio (SQL file to be exact) and run the command I get the following in the output window:

If I run the format.bat file manually via command line it works and formats the file.
It seems to me there is an environment setting that can be set in the .bat file or modifying something to resolve this issue.
We want to use DataGrip for our standard formatting tool and our projects (SQL at least) are in Visual Studio SQL Projects (aka SSDT). Having the ability to run formatting on those documents in the Visual Studio environment saves so much time. The alternative is to run it IN DataGrip which requires opening/formatting/closing lots of things.
Any suggestions?
Thanks!
请先登录再写评论。