Microsoft® Command Line Utilities 14.0 for SQL Server®
Microsoft Command Line Utilities 14.0 for SQL Server
Important! Selecting a language below will dynamically change the complete page content to that language.
Version:
14.0
Date Published:
8/2/2018
File Name:
x64\MsSqlCmdLnUtils.msi
x86\MsSqlCmdLnUtils.msi
File Size:
2.4 MB
2.2 MB
The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
The new SQLCMD supports Azure AD authentication for SQL DB and DW as well as Always Encrypted features (see SQLCMD Utility Details ).
The new BCP supports Azure AD authentication for SQL DB and DW (see BCP Utility Details ).Supported Operating Systems
Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2
Note: This component requires both Windows Installer 4.5 and Microsoft ODBC Driver 13.1 for SQL Server .- Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.
To check the SQLCMD version execute “sqlcmd -?” command and confirm that 14.0 version or higher is in use. To check the BCP version execute "bcp /v" command and confirm that 14.0.3008 or higher is in use. - Community Support: SQL Server Data Access Forum.
Submit Feedback: Microsoft SQL Server Feedback Center.
Documentation: ODBC Driver on Windows Documentation.
Team Blog: Microsoft ODBC Driver team blog
ODBC Driver