.net 安装 BCP 而不在客户端机器上安装 SQL Server?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/5295049/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Installing BCP without installing SQL Server in client machine?
提问by Ramakrishnan
I export data from database using the BCPutility, I want to install bcp in client machine. I don't want to install SQL Server 2008 in client machine.
我使用该BCP实用程序从数据库导出数据,我想在客户端机器上安装 bcp。我不想在客户端机器上安装 SQL Server 2008。
Is their any minimal installers available to install just bcp?
他们是否有任何最小安装程序可用于仅安装 bcp?
This is urgent task. Thanks in advance
这是一项紧迫的任务。提前致谢
采纳答案by gbn
You have to use one of the SQL Server distributable packagesto stay within licensing terms. Specifically "Microsoft SQL Server 2008 Command Line Utilities"
您必须使用SQL Server 可分发包之一才能遵守许可条款。特别是“Microsoft SQL Server 2008 命令行实用程序”
Note: copying bcp.exe by itself will not work
注意:单独复制 bcp.exe 是行不通的
Edit: latest download link: SQL Server distributable packages
编辑:最新下载链接:SQL Server 可分发包
Edit: an even later download link: SQL Server 2008R2 Feature Pack
编辑:更晚的下载链接: SQL Server 2008R2 Feature Pack
回答by AEQ
2015- Installed on Windows Server 2008 R2 SP1
2015- 安装在 Windows Server 2008 R2 SP1 上
I needed the ODBC driver installed first...
我需要先安装 ODBC 驱动程序...
Microsoft? ODBC Driver 11 for SQL Server
微软?用于 SQL Server 的 ODBC 驱动程序 11
http://www.microsoft.com/en-za/download/details.aspx?id=36434
http://www.microsoft.com/en-za/download/details.aspx?id=36434
Microsoft? Command Line Utilities 11 for SQL Server
微软?用于 SQL Server 的命令行实用程序 11
http://www.microsoft.com/en-za/download/details.aspx?id=36433
http://www.microsoft.com/en-za/download/details.aspx?id=36433
p.s. In case you're reading this post and the year is > 2015, use the search to find a similar download:
ps 如果您正在阅读这篇文章并且年份 > 2015,请使用搜索找到类似的下载:
http://www.microsoft.com/en-za/search/DownloadResults.aspx?q=Microsoft%20Command%20Line%20Utilities
http://www.microsoft.com/en-za/search/DownloadResults.aspx?q=Microsoft%20Command%20Line%20Utilities
回答by cwalet
well,just put the file below into c:/windows/
好吧,把下面的文件放到c:/windows/
sqlncli.dll
bcp.exe
bcp.rll
i tested on windows xp with which the 3 files come from sql server 2005 client
我在 windows xp 上进行了测试,其中 3 个文件来自 sql server 2005 客户端

