How Can I export and Import a larger database such as 2 Tb from/to Azure SQL Database ?

Question

How Can I export and Import a larger database such as 2 Tb from/to Azure SQL Database ?

Prasanna, Prashanth (RIS-CON) 20

Is it possible to Export/Import Backpac file to Azure Blob Storage when database size is 2 TB ? I have seen that limitation is 200 GB. is it increased now ?

SSingh-MSFT 16,371 Reputation points Moderator

2023-05-11T03:57:28.8833333+00:00

Hi Prasanna, Prashanth (RIS-CON) •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue

2 answers

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2023-05-11T03:57:28.8833333+00:00

Hi Prasanna, Prashanth (RIS-CON) •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue

Answer 1

SSingh-MSFT 16,371 Moderator

Hi Prasanna, Prashanth (RIS-CON) •,

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

As I understand, you want to know the limit of Database size in Export of Bacpac.

If you are exporting to blob storage, the maximum size of a BACPAC file is 200 GB. To archive a larger BACPAC file, export to local storage with SqlPackage.

Reference Document: Export to a BACPAC file - Azure SQL Database Considerations

Hope the information helps. Please let us know if you face any issue in performing this export.

If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Thank you.

Prasanna, Prashanth (RIS-CON) 20 Reputation points

2023-05-09T07:22:38.6433333+00:00

Hi, I know the limitation is 200 GB. I have mentioned it in my description as well. I dont want to export it to local storage as it is has sensitive data and as per company policy I cannot export it to local . Are there any ways to export and store it in azure and import it to create a new database under new server which is under new subscription?

Answer 2

SSingh-MSFT 16,371 Moderator

Thanks for now providing the details of your requirement.

You could go ahead with Copy Database option mentioned here: Copy a transactionally consistent copy of a database in Azure SQL Database.

Refer to the Copy to Different Server and Different Subscription section for more information.

Share via

How Can I export and Import a larger database such as 2 Tb from/to Azure SQL Database ?

2 answers

Your answer