Support for Import bacpac in azurerm_mssql_database

[frugecn]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

With the creation of the new azurerm_mssql_database resource, some parameters were not ported across. Import from bacpac was one of the features not ported across from azurerm_sql_database.

New or Affected Resource(s)

• azurerm_mssql_database

Potential Terraform Configuration

import supports the following:

storage_uri - (Required) Specifies the blob URI of the .bacpac file.
storage_key - (Required) Specifies the access key for the storage account.
storage_key_type - (Required) Specifies the type of access key for the storage account. Valid values are StorageAccessKey or SharedAccessKey.
administrator_login - (Required) Specifies the name of the SQL administrator.
administrator_login_password - (Required) Specifies the password of the SQL administrator.
authentication_type - (Required) Specifies the type of authentication used to access the server. Valid values are SQL or ADPassword.
operation_mode - (Optional) Specifies the type of import operation being performed. The only allowable value is Import.

### References

https://www.terraform.io/docs/providers/azurerm/r/sql_database.html

[michaelbertoni]

Any update on this feature?

[v4ld3r5]

I'm also interested on this functionality

[lotaezhao]

I was trying to do this now and shocked to see azurerm_sql_database has it but azure_mssql_database doesn't! Please, if replacing deprecated resources can we at least get 1 to 1 feature parity. Quite a common scenario, needing to import a database from a different environment that you don't have access to. Please can this be added.

[nmaarse]

I also require this feature. When recreating a new azure environment with an azure sql database you want to be able to restore the database from a bacpac file. The altenative is to do this via az cli, but then terraform state gets mixed up and i cannot get the terraform import to work after that to sync up.

So please merge this import into the azurerm_mssql_database.

[rille111]

How can this not be supported? Didnt know about this from the start, and that s-cks now that we spent so many days on learning and using Terraform.

[abhishekjerry2000]

Any updates about this feature.

[romina2001]

Any news on this feature? Is there any work around for it?

[OwendotKim]

I desperately want this feature

[ovidiubuligan]

After this is implemented ,will it have the same recommandation as google sql terraform provider ? :

[alexvolox2]

This feature is required, anyone who needs to migrate from on-prem SQL to managed SQL will need to pass from an import from bacpac........

[fcatacut]

@katbyte @tombuildsstuff I think that this can be closed as implemented in v3.27.0. See PR #18588.