英文:
Where Is Microsoft Command Line Utilities 16?
问题
问题描述
看起来微软的命令行工具的最新版本与SQL Server 2022分发的版本不一致。
- SQL Server 2022提供
bcp和sqlcmd的版本为16。 - 命令行工具安装程序提供的版本是15。
查找文档
SQL Server 2022的安装程序将引导您到此链接以安装命令行工具，其中包括bcp和sqlcmd。
该链接提供SQL Server工具链接
该链接为bcp和sqlcmd提供了链接。它们都提供相同的下载Microsoft Command Line Utilities 15 for SQL Server (x64) (2.6 MB)下载链接。
问题
当您安装此工具时，将获得版本15的bcp和sqlcmd。
直接安装SQL Server 2022时，将获得相同工具的版本16。
顺便说一句：如果您在bcp和sqlcmd版本16上安装最新的命令行工具，最新版本将被保留。命令行工具安装程序不会覆盖。
我的问题
- 版本15的这些工具与SQL Server 2022兼容吗？我没有看到文档说明兼容。
- 版本16的这些工具可下载吗？例如，我没有看到Microsoft Command Line Utilities 16 for SQL Server (x64)的下载链接。
- 版本16的
bcp和sqlcmd是否有更改日志？
英文:
Problem Statement
It seems the latest version of Microsoft's Command Line Utilities aren't at the same version that is distributed with SQL Server 2022.
- SQL Server 2022 delivers
bcpandsqlcmdversion 16. - The command line utility installer delivers version 15.
Finding the documentation
SQL Server 2022's installer will direct you to this link to install the command line utilities which get you bcp and sqlcmd.
Which provides the SQL Server Tools link
Which gives you a link for bcp and sqlcmd. They both give you the same Download Microsoft Command Line Utilities 15 for SQL Server (x64) (2.6 MB) download link.
The Problem
When you install this you will get version 15 of bcp and sqlcmd.
When you install SQL Server 2022 directly, you will get version 16 of the same tools.
Just as a side note: if you install the latest command line utils over bcp and sqlcmd version 16, the newest version is retained. The command line utils installer won't overwrite.
My Questions
- Are version 15 of these tools compatible with SQL Server 2022? I didn't see documentation saying that it was.
- Are version 16 of these tools downloadable? For example, I didn't see a download link for Microsoft Command Line Utilities 16 for SQL Server (x64) anywhere.
- Is there a change log for version 16 of
bcpandsqlcmdanywhere?
答案1
得分: 1
Microsoft正在更新SQL Server 2019附带的版本15（SQL v15）。
最初，并非所有2022功能都可用，但似乎所有旧功能都可以正常工作。
Microsoft于2023年4月23日发布了一次更新，将2022功能添加到SQLCMD和BCP的命令行工具中，该更新适用于SQL命令行工具版本15（即与SQL2019关联的发布）。
2022兼容版本是15.0.4298.1。
您可以通过以下链接下载命令行实用程序，安装sqlcmd和bcp。https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16 将返回最新版本。
新的2022功能在页面上有描述，与其他内容并列，但不是正式的更改日志。
英文:
Microsoft are updating v15 as initially shipped with 2019 (SQL v15)
Initially, not all 2022 features were available, but all the old ones seem to work.
Microsoft released an update including 2022 features for SQLCMD and BCP as an update to the command line tools for SQL Command line Tools v15 (ie, the release associated with SQL2019) on April 23rd 2023.
The 2022 compatible version is 15.0.4298.1
Your link to download the command line utilities to install both sqlcmd and bcp. https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16 will return the most current version.
The new 2022 features are described on the page, alongside everything else but it is not a change log as such.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论