what is the alternative of XP_CMDshell ? it is working fine in sql server but it is not support in sql azure so what is alternative for sql azure ?
XP_CMDshell的替代方案是什么？它在sql server中工作正常，但它不支持sql azure所以sql azure的替代方法是什么？
1 个解决方案
#1
3
I assume you need command line access to access BCP since you are trying to create and upload/download data into a flat or xml file.
我假设您需要命令行访问才能访问BCP，因为您尝试创建并上载/下载数据到flat或xml文件中。
SQL Azure does not provide access to a command prompt. Think of SQL Azure as just a virtualized service, without host infrastructure (Virtualized or physical). Since BCP is actually a command line based utility you won't have access to it from Azure. You'll want to setup BCP, which is part of the command line utilities, on a machine that does have access to command line. That machine might be either on-premise or Azure IaaS. You can install just the BCP component.
SQL Azure不提供对命令提示符的访问。将SQL Azure视为虚拟化服务，无需主机基础架构（虚拟化或物理）。由于BCP实际上是基于命令行的实用程序，因此您无法从Azure访问它。您需要在可以访问命令行的计算机上设置BCP，它是命令行实用程序的一部分。该机器可能是内部部署或Azure IaaS。您只能安装BCP组件。
http://www.microsoft.com/en-us/download/details.aspx?id=36433
http://www.microsoft.com/en-us/download/details.aspx?id=36433
Alternatively if you don't want to setup physical infrastructure to complete this, Azure Data Factory would be able to complete the task of moving data between flat files and databases.
或者，如果您不想设置物理基础结构来完成此操作，Azure数据工厂将能够完成在平面文件和数据库之间移动数据的任务。
#1
3
I assume you need command line access to access BCP since you are trying to create and upload/download data into a flat or xml file.
我假设您需要命令行访问才能访问BCP，因为您尝试创建并上载/下载数据到flat或xml文件中。
SQL Azure does not provide access to a command prompt. Think of SQL Azure as just a virtualized service, without host infrastructure (Virtualized or physical). Since BCP is actually a command line based utility you won't have access to it from Azure. You'll want to setup BCP, which is part of the command line utilities, on a machine that does have access to command line. That machine might be either on-premise or Azure IaaS. You can install just the BCP component.
SQL Azure不提供对命令提示符的访问。将SQL Azure视为虚拟化服务，无需主机基础架构（虚拟化或物理）。由于BCP实际上是基于命令行的实用程序，因此您无法从Azure访问它。您需要在可以访问命令行的计算机上设置BCP，它是命令行实用程序的一部分。该机器可能是内部部署或Azure IaaS。您只能安装BCP组件。
http://www.microsoft.com/en-us/download/details.aspx?id=36433
http://www.microsoft.com/en-us/download/details.aspx?id=36433
Alternatively if you don't want to setup physical infrastructure to complete this, Azure Data Factory would be able to complete the task of moving data between flat files and databases.
或者，如果您不想设置物理基础结构来完成此操作，Azure数据工厂将能够完成在平面文件和数据库之间移动数据的任务。