Data Portability Overview

How can I keep control over my data?

Customers own their data, and cloud platforms should make it easy and efficient to securely move customers’ data in and out.

When customers create data in an on-premises application, they have a high level of confidence that they have control over the data stored in the on-premises environment. Customers should have a comparable level of control over their data when they are using cloud platforms.

Scenarios and Technical Illustrations

Interoperability Surfaces for Data Portability

Windows Azure provides a variety of interoperability surfaces that developers can use to move data in and out of Azure Storage, Windows Azure SQL Databases, or Windows Azure Marketplace. These interoperability surfaces are enabled through a combination of standards support and documented APIs and protocols.

Details...

Support for Open Data Protocol (OData) in Windows Azure

Open Data Protocol (OData) is a web protocol for querying and updating data. It provides developers with a way to unlock data and free it from the silos that exist in applications today.

Details...

Migrating SQL Server Data to Hadoop with Sqoop

You can use Hadoop on Azure to process structured data stored in relational databases such as SQL Server, in addition to processing unstructured data from other sources. Apache Hadoop Sqoop (SQL-to-Hadoop) is a tool that allows you to import structured data to Hadoop, where it can be processed in MapReduce and HIVE jobs.

Details...

Mount a Durable Hard Drive Volume in the Cloud with Windows Azure Drives

Most, if not all applications, require a durable data store. Whereas many applications use a relational database engine for durable storage, many others write content directly to a file system. Windows Azure drives are an infrastructure solution that provides a durable NTFS volume within Windows Azure, thus enabling users to move their data to the cloud and bring it back to their local infrastructure as needed.

Details...

Moving Data in and out of Windows Azure SQL Databases and Blob Storage

Windows Azure SQL Database and Windows Azure blog storage provide a variety of interoperability surfaces for data portability. You can easily move data between SQL Database in the cloud and on-premises SQL Server, or between local file systems, other cloud providers, and Windows Azure blob storage.

Details...