title: Azure Data Sync - Copy Each SQL Row to Blob
body: <p>I'm trying to understand the best way to migrate a large set of data - ~ 6M text rows from (an Azure Hosted) SQL Server to Blob storage. </p>
  
  <p>For the most part, these records are archived records, and are rarely accessed - blob storage made sense as a place to hold these. </p>
  
  <p>I have had a look at Azure Data Factory and it seems to be the right option, but I am unsure of it fulfilling requirements. </p>
  
  <p>Simply the scenario is, for each row in the table, I want to create a blob, with the contents of 1 column from this row. </p>
  
  <p>I see the tutorial (i.e. <a href="https://docs.microsoft.com/en-us/azure/data-factory/data-factory-copy-activity-tutorial-using-azure-portal" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/data-factory/data-factory-copy-activity-tutorial-using-azure-portal</a>) is good at explaining migration of bulk-to-bulk data pipeline, but I would like to migrate from a bulk-to-many dataset. </p>
  
  <p>Hope that makes sense and someone can help?</p>