What Azure services to use to export Table data from Azure sql to a flat file securely.

Christopher Disilva Hirudayanathan 5 Reputation points
2023-08-23T21:25:39.6733333+00:00

Flat file should be stored in a secured place in some azure services. No transformation required during export & No manual querying from azure or no manual uploading of flat file.

Import of flat file may be done by consumer by manually downloading it or might be automated through azure services.

Azure Database Migration service
Azure SQL Database

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-08-24T04:18:02.7+00:00

    Hi
    Christopher Disilva Hirudayanathan     •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you want to export Azure SQL Database Table data to a flat file directly.

    Please open Query Editor through Azure Portal on the Database. Then Open Table and display content of the table using query and use option to export as csv, as shown in the below gif:

    SQLDBQuerySave

    Please try if this helps for your case.

    Also let us know the configuration details of your Azure SQL Database, number of records to be exported etc so that we can suggest you other options if above does not help.

    Thanks

  2. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-08-25T08:41:44.4366667+00:00

    Hi
    Christopher Disilva Hirudayanathan     •,

    Thanks for the details.

    You may use https://video2.skills-academy.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-ver16 to do encryption of column of data.

    Could perform Dynamic Data Masking too using Mask Functions as shown below:

    User's image

    Also, you could use Azure Data Factory/Azure Synapse Analytics/Azure Databricks to accomplish same result.

    Let us know if you have more questions on the usage.

    Thanks

    0 comments