Updating sql.el sql-ms functions to operate with sqlcmd

Updating sql.el sql-ms functions to operate with sqlcmd

[Ryan Knauber]

[-- Attachment #1: Type: text/plain, Size: 617 bytes --]

Hello,
I'm interested in migrating the Microsoft SQL Server portion of sql.el from "osql" to "sqlcmd". It looks like "osql" was deprecated a good while ago:https://docs.microsoft.com/en-us/sql/tools/osql-utility?view=sql-server-ver15https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15
I have very little experience in Elisp and modifying Emacs so far, but I love it. I also use MSSQL regularly, and if I could chat with someone briefly about how to go about working the modification, I'd be happy to contribute.
Best regards,
-----Ryan Knauberhttps://github.com/recholsknauber
972-953-7654

[-- Attachment #2: Type: text/html, Size: 1687 bytes --]

Re: Updating sql.el sql-ms functions to operate with sqlcmd

[Nikolay Kudryavtsev]

Sqlcmd has a very similar command line interface to osql and sql.el 
works fine with it. I think there was some minor incompatibilty in one 
or two args, but unfortunately I forgot to write it down.

Just in case, here's my working setup for sqlcmd:

(setq sql-ms-options (quote ("-W" "-s" "|" "-I"))
            sql-ms-program "sqlcmd")

So I think the work is pretty trivial - just play around with args until 
you settle down on a proper set of defaults and patch them in.

-- 
Best Regards,
Nikolay Kudryavtsev