Honestly, I found one of early benefits of go-sqlcmd was that it has
QUOTED_IDENTIFIER set to
ON by default (unlike
sqlcmd) and the
-I switch (to enable Quoted Identifiers in the "old" sqlcmd) has been removed; you have to put
SET QUOTED_IDENTIFIER OFF; in the batch. Plus that it's also usable on ARM is great; means I can use it on my RasPi running Azure SQL Edge. 🙂
I "upgraded(?)" to go-sqlcmd at home about a month ago, and I've honestly not regretted it. Though, I can imagine that if Microsoft want to replace sqlcmd with it, it's going to be a breaking change for a lot of people; the
-P switch has also been removed, for example (for good reason!!!). I'm a but confused that they named it
sqlcmd too and not
sqlcmd-go in the command line, to avoid such problems.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.