SQL Server .bacpac file from "Export Data-Tier Application" to Azure - local storage requirements?

g9icjywg 于 2023-06-21 发布在其他

关注(0)|答案(1)|浏览(165)

I have a large 350GB database (local server) I need to create a .bacpac file of. We're looking at using Azure Blob storage as the target, since there is only 49GB of free space remaining on the local servers. When going through the dialogs, it asks where to put the temporary file... does this mean the .bacpac file is generate entirely on the local system before being sent to Azure?

sql-server

来源：https://stackoverflow.com/questions/76484789/bacpac-file-from-export-data-tier-application-to-azure-local-storage-requir

1条答案

按热度按时间

lb3vh1jj1#

When you want to export the database from the SSMS to the Azure blob storage

On Export Settings Page you need to select Save to Azure option. You must connect to an Azure container in order to validate this option. It Creates a BACPAC file in a specified Azure container.
Be aware that using this option requires selecting a local directory for the temporary file. Keep in mind that once the process is finished, the temporary file will still be there where it was created.
During the export process, SSMS generates a temporary .bacpac file on your local system, as specified by the local directory you provide.
After the operation completes and the .bacpac file is transferred to Azure storage, the temporary file will remain in the specified local directory unless you manually delete it.

To ensure a successful export, make sure to have enough free space in the specified local directory to accommodate the temporary .bacpac file.

Reference: Export a Data-tier Application

赞(0）回复(0）举报 2023-06-21

我来回答

SQL Server .bacpac file from "Export Data-Tier Application" to Azure - local storage requirements?

1条答案

相关问题

热门标签

最新问答