Azure SQL DB-从Azure SQL导出数据文件(.csv) [英] Azure SQL DB - data file export (.csv) from azure sql
问题描述
我是Azure SQL的新手. 我们有一个位于Azure SQL中的客户端数据库.我们需要设置流程自动化，将查询结果提取到.CSV文件并将其加载到我们的服务器中(在内部SQL Server 2008 R2中).
I am new to Azure SQL. We have a client db which is in Azure SQL. We need to set up a process automation which extract query results to .CSV files and load it in our server (on premise SQL server 2008 R2).
从Azure sql生成csv文件并使本地服务器可访问的最佳方法是什么?
What is the best method to generate csv files from Azure sql and make it accessible for the on premise server?
推荐答案
老实说，就专业方法而言，最好的方法是在内部使用Azure数据工厂和Integration Runtime的安装.
Honestly the best in terms of professional approach is to use Azure Data Factory and installation of Integration Runtime on the on premises.
您当然可以使用BCP，但从长远来看，这将很麻烦.很多脚本，表格，维护.没有日志记录，没有指标，没有警报...不要老实地做.
You of course can use BCP but it will be cumbersome in the long run. A lot of scripts, tables, maintenance. No logging, no metrics, no alerts... Don't do it honestly.
SSIS是另一种选择，但我认为它比ADF解决方案需要更多的努力.
SSIS is another option butin my opinion it takes more effort than ADF solution.
Azure Data Factory将允许您使用无编码的用户界面以专业的方式进行此操作.还可以对其进行参数化，因此您只需更改表名称参数的名称，然后突然就可以轻松地导出20、50或100个表.
Azure Data Factory will allow you to do this in professional way using user interface with no coding. It also can be parametrized so you just change name of table name parameter and suddenly you are exporting 20, 50 or 100 tables at ease.
这里是视频示例，如果您想快速浏览一下，请介绍数据工厂.在此概述中，还有一个将CSV导入Azure SQL的演示，您可以对其稍作更改以使Azure SQL-> CSV和CSV> SQL Server或直接成为Azure SQL> SQL Server.
Here is video example and intro into data factory if you want to see quick overview. In this overview there is also demo which imports CSV to Azure SQL, you can just change it a little bit to make Azure SQL -> CSV and CSV > SQL server or just directly Azure SQL > SQL server.
这真的很简单.
这篇关于Azure SQL DB-从Azure SQL导出数据文件(.csv)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
