Can we pass database type in import action of SqlPackage

Question

I downloaded a BACPAC file using export command of sql package in Azure SQL Database, that database belonged to an elastic pool now I want to add the new database inside an elastic pool only.

How to do this ?

Answer 1

Hi @Ayush Shrivastava,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

We would like to inform you that, To add a newly created database from a BACPAC file into an Elastic Pool in Azure SQL Database. You can import a SQL Server database into Azure SQL Database or SQL Managed Instance using a .bacpac file. The .bacpac file can be imported either from Azure Blob Storage (standard storage only) or from local storage in an on-premises environment. To optimize the import speed, it is recommended to scale the database to a higher service tier and compute size during the import process, you can scale it back down after the import is successfully completed.

Kindly note that, Machines processing import/export requests submitted through the Azure portal or PowerShell need to store the bacpac file as well as temporary files generated by the Data-Tier Application Framework (DacFX). The disk space required varies significantly among databases with the same size and can require disk space up to three times the size of the database. Machines running the import/export request only have 450GB local disk space. As a result, some requests might fail with the error There is not enough space on the disk. In this case, the workaround is to run SqlPackage on a machine with enough local disk space. We encourage using SqlPackage to import/export databases larger than 150GB to avoid this issue.

Please refer to the below mentioned links for more information.

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?view=azuresql&tabs=azure-powershell

https://github.com/uglide/azure-content/blob/master/articles/sql-database/sql-database-import.md

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.