mssql-cli icon indicating copy to clipboard operation
mssql-cli copied to clipboard

Published 20 hours ago • verified publisher icon dbcli

Always Encrypted

Open MiguelAtTweddle opened this issue 6 years ago • 3 comments

Is it possible to use mssql-cli with a database which has Always Encrypted feature on certain fields?

MiguelAtTweddle avatar Jan 31 '19 12:01 MiguelAtTweddle

Not at the moment. mssql-cli uses the .NET Core System.Data.SqlClient driver to connect to SQL Server, and this driver does not yet Always Encrypted columns.

If/when support is added to the Microsoft.Data.SqlClient driver for Always Encrypted, we'll make the move to this driver. Microsoft.Data.SqlClient support Always Encrypted is tracked by issue https://github.com/dotnet/SqlClient/issues/11.

pensivebrian avatar Jul 29 '19 20:07 pensivebrian

https://github.com/dotnet/SqlClient/issues/11 has been closed, and it looks like you already moved to Microsoft.Data.SqlClient in https://github.com/microsoft/sqltoolsservice/pull/865. Does mssql-cli now support Always Encrypted, then?

KalleOlaviNiemitalo avatar May 14 '20 08:05 KalleOlaviNiemitalo

Not yet, but we're close now that all dependencies support the feature. All I think we need todo is wire up the '-g (enable column encryption)' parameter to set a value in the connection string when connecting to SQL Server. I don't have a timeline, but I'm hoping we can address this soon.

pensivebrian avatar May 14 '20 21:05 pensivebrian