Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Exporting data from Azure DocumentDB

is there an option in Azure to export an existing collection from DocumentDB?

I could only seen an Import option.

like image 219
Codehelp Avatar asked Jun 09 '15 09:06

Codehelp


People also ask

How do I export data from Azure?

Create an export job in your source storage account in Azure portal. Specify source blobs or container paths for the data to be exported. Provide the return address and carrier account number for shipping the drives back to you. Ship the disk drives to the shipping address provided during job creation.

How do I transfer data from one Azure Cosmos DB to another?

Import from a SQL API collectionThe Azure Cosmos DB source importer option allows you to import data from one or more Azure Cosmos containers and optionally filter documents using a query. Use the Verify command to ensure that the Azure Cosmos DB instance specified in the connection string field can be accessed.

How do I transfer data from Cosmos DB to SQL Server?

The quickest one is to use Document DB / Cosmos DB Migration Tool. This is a tool provided by Microsoft to migrate data TO/FROM various sources such as MongoDB, JSON, csv and SQL Server to Cosmos DB.


1 Answers

There is no built-in export option in the database service itself. However, the DocumentDB Data Migration Tool, published by the DocumentDB team, is available and provides both import and export capabilities (export is to JSON). Everything is documented on the DocumentDB area of the Azure site, specifically here.

This isn't your only option, as you can write your own export app based on one of the existing language SDKs or direct REST API calls.

There may be other tools available, but getting into a which is the best tool for this discussion is off-topic. I'm only pointing out the Data Migration tool because the DocumentDB team provides it, along with official documentation.

like image 59
David Makogon Avatar answered Sep 30 '22 17:09

David Makogon