Bacpac import needs the ability to add database in elastic pool
Currently, the bacpac import functionality will not let you add the database in an elastic pool. You need to set the tier first during the import. We have an application that let end user add a database from the bacpac file and we need to set the tier then import the bacpac then add it to the elastic pool. The ability to add the database during the bacpac import process to existing elastic pool will save us time and effort. This feature is very important to us users as we can have the flexibility to either add the database from the bacpac import to the elastic pool or set a premium or standard tier.
Dave Digdo commented
Raman Gupta commented
It is odd this is not supported because the Azure portal export/import functionality is not symmetric -- one can export from the portal, but one cannot import the same way. You can only import into a regular non-elastic database.
Stefanos Evangelou commented
Definitely a useful feature, needs to be added to Azure. What would be the alternative way to carry out a .bacpac import into Azure SQL elastic pool ?
Michael Khalsa commented
I also would like this feature
I would also like this feature as well
Estienne Granet commented
Thank you for taking the time to submit this feedback. There are currently no plans to support elastic pools with the import feature. We’ll keep this suggestion open for further consideration though and monitor community and customer interest.