-
Notifications
You must be signed in to change notification settings - Fork 4.6k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support for Import bacpac in azurerm_mssql_database #6282
Comments
This comment has been minimized.
This comment has been minimized.
Any update on this feature? |
I'm also interested on this functionality |
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. |
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. |
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. |
Any updates about this feature. |
Any news on this feature? Is there any work around for it? |
I desperately want this feature |
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........ |
@katbyte @tombuildsstuff I think that this can be closed as implemented in v3.27.0. See PR #18588. |
Community Note
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)
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.
The text was updated successfully, but these errors were encountered: