| Capability | Azure CLI | AzCopy | PowerShell | AdlCopy | PolyBase |
|---|---|---|---|---|---|
| Compatible platforms | Linux, OS X, Windows | Linux, Windows | Windows | Linux, OS X, Windows | SQL Server, Azure Synapse |
| Optimized for big data | No | Yes | No | Yes 1 | Yes 2 |
| Copy to relational database | No | No | No | No | Yes |
| Copy from relational database | No | No | No | No | Yes |
| Copy to Blob storage | Yes | Yes | Yes | No | Yes |
| Copy from Blob storage | Yes | Yes | Yes | Yes | Yes |
| Copy to Data Lake Store | No | Yes | Yes | Yes | Yes |
| Copy from Data Lake Store | No | No | Yes | Yes | Yes |
| Capability | Azure Storage Explorer | Azure portal * | Azure Data Factory |
|---|---|---|---|
| Optimized for big data | No | No | Yes |
| Copy to relational database | No | No | Yes |
| Copy from relational database | No | No | Yes |
| Copy to Blob storage | Yes | No | Yes |
| Copy from Blob storage | Yes | No | Yes |
| Copy to Data Lake Store | No | No | Yes |
| Copy from Data Lake Store | No | No | Yes |
| Upload to Blob storage | Yes | Yes | Yes |
| Upload to Data Lake Store | Yes | Yes | Yes |
| Orchestrate data transfers | No | No | Yes |
| Custom data transformations | No | No | Yes |
| Pricing model | Free | Free | Pay per usage |
No comments:
Post a Comment