Microsoft Azure Stack is an extension of Azure – bringing the agility and innovation of cloud computing to your on-premises environment and enabling the only hybrid cloud that allows you to build and deploy hybrid apps anywhere. We bring together the best of the edge and cloud to deliver Azure services anywhere in your environment.

Easily Import Data to DocumentDB

A common request we’ve heard from customers is, “How can I easily migrate data to DocumentDB?” While there are lots of different approaches, it’s hard to imagine one easier than the DocumentDB Data Migration tool, an open source solution that imports data to DocumentDB from a variety of sources, including:

JSON files

MongoDB

SQL Server

CSV files

DocumentDB collections

Setting up an import through the tool’s graphical user interface (dtui.exe) is a simple operation. Choose the import source and provide the applicable information: Specify import options: Confirm the import settings and click Import: The tool can also be driven from the command line (dt.exe). In fact, after setting up an import through the UI, there is an option to output the associated command: What's more, the tool supports transforming tabular source data (e.g. SQL Server or CSV files) such that hierarchical relationships (subdocuments) can be created during import, as well as, options for handling date fields. The migration tool source code is available on GitHub and a compiled version is available from Microsoft Download Center. You may either compile the solution or simply download and extract the compiled version to a directory of your choice. For full details on how to use the tool, including command line samples for each data source option, head over to my article here. To learn more about DocumentDB, please visit our service page.