Microsoft Codename “Data Transfer” (https://web.datatransfer.azure.com) is a cloud service that lets you transfer data from your computer to a SQL Azure database or Windows Azure Blob storage account that you own. You can upload any data format to Windows Azure Blob storage, and data that is stored in comma-separated value (CSV) or Microsoft Excel format (.xlsx) to a SQL Azure database. When you upload data to a SQL Azure database, it is transformed into database tables.
To use the Data Transfer service, you must have the following:
Microsoft Codename “Data Transfer” is located at:
https://web.datatransfer.azure.com/ The home page looks like this:
On the top of the home page, there are tabs designated for importing data,
managing datasets and managing data stores.
On the Import tab, you have the options to import data into SQL Azure or
Windows Azure Blob services. You can import comma-separated value (csv or txt)
or Excel (.xlsx) data to a SQL Azure database. When you upload to a database,
the Data Transfer service transforms your tabular data into database tables.
The SQL Azure import process allows you to create or select a SQL Azure
Note The User format is [username]@[server], where [server]
is the name of the SQL Azure database server.
After you create or select a SQL Azure database connection, you start the
file transfer process.
When importing a tabular file into an existing SQL Azure table, the file
transfer process performs an Update or Replace operation. Update is an upsert
operation that updates an existing row if the primary key can be found;
otherwise, the row is inserted. Replace is a truncate and insert operation.
From the Choose a file to transfer page, select the
Update Table or Replace Table option.
Click Analyze to transform your data to database tables.
On the Drag source file columns to match target table
page, create a Source file to Target table mapping. For more information,
see Source file to Target table Mapping.
Click Save to upload your data to the SQL Azure
The My Data page is displayed with information about
your upload. For more information, see
Manage Your Datasets.
A source file is mapped into a target table using the Drag source
file columns to match target table page. The page initially contains
four columns: an Unmapped Source file column containing data column tiles, an
empty Source file Mapped column, an empty Target table Mapped column, and an
Unmapped Target table column containing data column tiles. Drag Unmapped data
column tiles into Mapped columns to create a Source file to Target table
Initial Source file to Target table mapping page
Mapped Source file to Target table mapping page
A Source file to Target table mapping can include a partial list of data
column tiles as illustrated below.
The Windows Azure Blob import process allows you to create or select a
Windows Azure Blob connection.
Note The Container name must be 3 – 63 characters long
containing only lowercase alphanumeric characters or dashes.
After you create or select a Windows Azure blob connection, you start the file transfer process. The file transfer process supports
Numerics Binary Format which is used in Cloud Numerics. Cloud Numerics is a SQL Azure Lab that lets you model and analyze data at scale. When uploading a file to Windows Azure Blob storage for use in Cloud Numerics, you can choose to have the file converted to the Numerics Binary Format. This only applies to .csv and Excel files that contain numerical data ready for analysis with Cloud Numerics.
The My Data page contains tabs that list all datasets and blobs you have
uploaded, along with the most recent job upload status.
Some errors that can occur during an upload to your database contain
additional information. If an error of this type occurs, your dataset will show
an Error link in the last job status column.
Click the Error link for more information. An error log is also
uploaded to the database as a table named ErrorLog_. The table contains a
list of detailed error information.
The My Stores page lists databases and storage accounts.
From this page, click Update to update the connection
information for an account or Remove to remove it from the
service. Removing a store from the service only removes it from the service and
does not affect the store or the data it contains. Any datasets associated with
the removed store are also removed from the service; however, they are not
removed from your database.
Update and Remove perform the same actions
for blob stores that they do for databases.
You can also click Rename on the blobs tab
to specify a new name for a blob container
Click I Have an Idea to tell us about how we can improve
Click I Found a Bug to send us email about what doesn’t work
so we can fix it.
Microsoft Codename “Data
Transfer” is a Windows Azure service that lets you easily upload data to a
SQL Azure database or a Windows Azure Blob storage account. When you upload data
to a SQL Azure database, your data is transformed into database tables. By
uploading your data to Windows Azure, you can make it quickly and easily
available to your users and applications around the world.