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
323 stars 56 forks source link

BCP supports with ODBC Driver 18 #526

Open mikependon opened 2 months ago

mikependon commented 2 months ago

We are using the BCP utility to bulk insert huge number of rows towards our Data Lake Data Warehouse (a dedicated SQL Pool in Azure) and it is kind of a very important capability to us.

The current released version of BCP is only supporting the ODBC Driver v17.

image

Our organization has already started the rollout of the ODBC Driver v18 to complement the requirement of Security Vulnerabilities.

Though we can still utilize the BCP in our Azure Kubernetes Services by just referencing the older version of mssqltools17 as defined here, but still it fails to run from various Windows-based platform now where has the updated ODBC drivers.

Is there a plan to support the latest ODBC driver v18? And if yes, when do we expect it? Thanks