Search code examples
azureazure-sql-databaseazure-blob-storageazure-files

When to use Azure blob storage versus Azure file share?

Azure newbie here. I have an architecture requirement to move the data from on-premise to cloud database. This is done in two steps due to security restrictions and timelines.

  1. Move the file to azure blob storage
  2. Read from the blob and Import to the sql database .

Azure blob is suggested for unstructured data. However, the data we want to export to cloud is a simple export of data from sql tables to csv files.

For such requirements what is recommended? Azure blob or Azure file share? When to use blob versus azure file share ?

Solution

  • Actually, if you want to migrate database from local/on-premise SQL Server to Azure SQL, there are many ways can help do that directly without Blob or File Storage.

    Such as:

    1. Using Data Migration Assistant(DMA) to help you migrate the data/database to Azure.

      Ref: Migrate on-premises SQL Server or SQL Server on Azure VMs to Azure SQL Database using the Data Migration Assistant

    2. SQL Server Management Studio(SSMS) task: Deploy Database to Microsoft Azure SQL Database.

      enter image description here

      Ref: Using the Deploy Database to SQL Azure Wizard in SQL Server Management Studio to move to the Cloud

    Of course you could export the sql server data as CSV files to Blob or File storage, then import the csv file to Azure SQL. In usually, we often use Blob Storage work with Azure SQL database. It's up to you, reference the document @Gaurav Mantri-AIS mentioned.

    Hope this helps.