I wanted to export some data directly from SQL Server to Azure Blob storage in compressed orc format but there doesn't seem to be a way export like Azure SQL DW using CETAS Statement? I am wondering why Microsoft didn't include this feature in SQL Server 2016.
Asked
Active
Viewed 117 times
-4
-
Any reason why my question is down voted? Just curious – HimalayanNinja Mar 22 '17 at 22:00
-
2It's not a question that can be answered by other users. If you want to know why MS did not or cannot include this feature in SQL Server, you'd have to ask them. You're better off asking how to accomplish something rather than asking for wild speculation on the whims of the gods. – mallan1121 Mar 22 '17 at 22:21
1 Answers
0
You can export data from SQL Server 2016 to Azure Blob using PolyBase by creating an external table and running an insert into statement.
ckarst
- 751
- 5
- 11
-
-
After doing number of testing I have found CETAS with insert into performs worst. – HimalayanNinja Mar 25 '17 at 01:21