locked
Is there a method of integrating archiving of data from our SQL data ware house in the cloud? RRS feed

  • Question

  • Is there a method of integrating archiving of data from our SQL data ware house in the cloud?

    We have a SQL data ware house which information specific to people.   We want to archive this information from either IaaS SQL, SQL Database, or SQL Managed Instance into a Blob?   We do need to preserve the formatting of the data so that it can be retrieved by the SQL data warehouse when necessary.   

    Please provide a suitable archiving solution.


    dsk

    Monday, June 3, 2019 10:24 PM

All replies

  • Is there a method of integrating archiving of data from our SQL data ware house in the cloud?

    We have a SQL data ware house which information specific to people.   We want to archive this information from either IaaS SQL, SQL Database, or SQL Managed Instance into a Blob?   We do need to preserve the formatting of the data so that it can be retrieved by the SQL data warehouse when necessary.   

    Please provide a suitable archiving solution.


    dsk

    Tuesday, June 4, 2019 12:48 PM
  • It is actually possible to backup Azure SQL Server and Restore to Azure Blob Storage, I'd recommend checking out the following link Let me know if this helps.

    Thanks,

    Adam

    Tuesday, June 4, 2019 11:12 PM
  • @kimdav111 Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
    Monday, June 10, 2019 10:15 AM