SQL Azure import bacpac issue

Question

SQL Azure import bacpac issue

JoelP 366

Hi,

I have exported an SQL Azure DB from the portal in a storage account. No issues exporting...

Now, I'm trying to import the bacpac into a new SQL Azure server from the portal but is giving me below issues. I have tried removing master key, import in premium tier, but no success

User's image

any suggestions?

Note: I tried importing ssms with success but taking a long time...

1 answer

Your answer

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Instead of that approach try to create a new database on the new Azure SQL logical server, while creating the new database, make a click on "Additional settings", and select Backup, to restore a point-in-time restore of the source database to the database you are creating.

User's image

JoelP 366 Reputation points

2023-05-25T04:21:15.63+00:00

Thanks Alberto. Unable to access backup from different subscriptions. I forgot to mention from dev subscription to prod subscription
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-05-25T05:04:49.93+00:00

What happen if you use PowerShell instead?

$ResourceGroupName = "RGName" $ServerName = 'ServerName' $DatabaseName = "DestinationDBName"

$StorageName = "StorageAccountName" $StorageKeyType = "StorageAccessKey" $StorageUri = "http://$StorageName.blob.core.windows.net/swwstoragecontainer/BackpacFileName.bacpac" $StorageKey = "***********************************"

$credential = Get-Credential

$importRequest = New-AzureRmSqlDatabaseImport -ResourceGroupName $ResourceGroupName -ServerName $ServerName -DatabaseName $DatabaseName -StorageKeytype $StorageKeyType -StorageKey $StorageKey -StorageUri $StorageUri -AdministratorLogin $credential.UserName -AdministratorLoginPassword $credential.Password ` -Edition Standard -ServiceObjectiveName S0 -DatabaseMaxSizeBytes 50000

Get-AzureRmSqlDatabaseImportExportStatus -OperationStatusLink $importRequest.OperationStatusLink
SSingh-MSFT 16,371 Reputation points Moderator

2023-05-29T06:31:40.83+00:00

Hi Joel Prescilla •,

Just checking if you got a chance to look at the previous comment by Alberto. Let us know if have already found a solution or need more help. Thank you
JoelP 366 Reputation points

2023-06-13T19:50:21.94+00:00

Hi All,

I had to use SSMS to import the database. A 50GB database took 8 hours to import

Share via

SQL Azure import bacpac issue

1 answer

Your answer