adventurous-butcher-54166
06/29/2023, 1:03 PMpulumi_azure_native
◦ 1.103.0
◦ 2.0.0b2
• Providing a blob URI to different parameters on sql.Database
but those only accept Azure resource IDs
◦ source_database_id
◦ source_resource_id
• Multiple Azure API versions
Furthermore, searching for the specific parameter names exposed by the /import
endpoint in the pulumi_azure_native.sql
module didn't give me anything:
• storageKey / storage_key
• storageUri / storage_uri
• blobUri / blob_uri
Is this API not represented in the SDK or do you know how to go about using sql.Database
to do this?rapid-engineer-94232
06/30/2023, 6:22 AMicy-doctor-13719
06/30/2023, 5:59 PMadventurous-butcher-54166
06/30/2023, 6:10 PMsqlpackage
cli.
There's a caveat though, as bacpac imports have to be done during the initial provisioning of the DB as it has to be completely empty.
The workaround to be able to restore from bacpac on a newly/already provisioned Azure SQL DB, as described here, is to drop all triggers, procedures, functions, tables, views etc. before running the sqlpackage bacpac import.
A bit hacky IMO but worked out ok...