microsoft / go-sqlcmd

The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)
https://learn.microsoft.com/sql/tools/sqlcmd/go-sqlcmd-utility
MIT License
337 stars 59 forks source link

Expand scope of sqlcmd config file to other client tools and drivers #238

Open apoorvdeshmukh opened 1 year ago

apoorvdeshmukh commented 1 year ago

As the adoption of this modern CLI increases, the config file generated by sqlcmd would be present everywhere the go-sqlcmd is used. The config file has all the information needed to establish a connection. It is further associated with a context name. Theoretically, any client driver or tool which has access to this config file should be able to establish a connection to the server by just accepting the context name from user application.

This issue is created to expand the scope of sqlcmd config file to contain other connection properties as well which the other tools and drivers can consume internally given a context name.

This also provides us with an opportunity to come up with common connection properties or a common format which all other drivers and tools can then uniformly consume and users don't have to deal with driver or tool specific connection string format.