How can we improve Azure SQL Database?

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.

70 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Myra Uy shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

6 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Raman Gupta commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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 ?

  • Estienne Granet commented  ·   ·  Flag as inappropriate

    Dear Myra,

    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.

    Best regards,
    Estienne

Feedback and Knowledge Base