I have exported a database which is about 200 G using the Azure portal . I saved it into a storage account. The bacpac file created is about 12 G.
The database is set to Standard S9: 1600 DTUs.
When i import i selected 1750 DTU and 1T of storage.
Then i tried to import the database using the Azure portal into a server but it wont import
It just gives the error:
The ImportExport operation with Request Id failed due to ‘The host process exceeded its memory allowance. Retries will not be successful. Please use SSMS or SqlPackage to complete the operation.’.
I have tried SSMS AND SQLPACKAGE and no difference same error.
So how can one use the Azure portal to export a database and not be able to import ?
Any reason why Azure cant import this , how can i imort the bacpac from Azure portal ? I did it all from the portal.