Import Data into SQL Azure or Blob storage Using Microsoft Codename "Data Transfer" Lab

Microsoft Codename "Data Transfer" Lab released today is an easy-to-use Web application to import your data into SQL Azure or Blob storage. Annoucing the release the SQL Server team explains "Importing your data into Azure is the first step. With Microsoft Codename "Data Transfer" Lab you can now transfer your data into Azure using any […]

Microsoft Codename Data Transfer LabMicrosoft Codename "Data Transfer" Lab released today is an easy-to-use Web application to import your data into SQL Azure or Blob storage. Annoucing the release the SQL Server team explains "Importing your data into Azure is the first step. With Microsoft Codename "Data Transfer" Lab you can now transfer your data into Azure using any standard modern browser."

The data transfer service transports files up to 200 MB in size through an HTTP SSL connection.

You'll need to supply your Windows Live ID credentials and Windows Azure account information to the service. If you don't have an account, sign up for a free trial.

Whether you're:

  • Preparing data for cloud analytics
  • Uploading files to power your Azure service or Web application
  • Propagating your data to SQL Azure for publication through Windows Azure Marketplace
  • Simply testing the Azure platform

"One of the goals we have for this lab is to take the complexity out of typical operations, such as loading structured data in CSV and Excel files into SQL Azure. In the interest of optimizing your time and resources, we're providing simple parsing, type discovery and conversion over your files," the SQL Server team said.

"You can choose to keep the defaults we provide, or override them. The transfer service first analyzes the file and presents you with our best guess. You'll be able to change the table name, column names, and data types before saving the file to SQL Azure," added SQL Server team.

More Info: Microsoft Codename "Data Transfer" Lab