Hi @Carolyn Schroeder ,
Welcome to Microsoft Q&A forum.
As I understand from the question, Import Database from bacpac failed for Azure SQL Server.
Could you please confirm if you are trying to perform Export/Import of Azure SQL Database or Azure Database for MySQL(Flexible Server)?
If it is Azure SQL Database, please take a look at the step by step documentation and video link below which might help:
Import a .bacpac file to a database in Azure SQL Database or Azure SQL Managed Instance
Export Import in Azure SQL Database
Please take care of the below Limitations during Import:
- Importing to a database in elastic pool isn't supported. You can import data into a single database and then move the database to an elastic pool.
- Import Export Service does not work when Allow access to Azure services is set to OFF. However you can work around the problem by manually running SqlPackage from an Azure VM or performing the export directly in your code by using the DacFx API.
- Import does not support specifying a backup storage redundancy while creating a new database and creates with the default geo-redundant backup storage redundancy. To workaround, first create an empty database with desired backup storage redundancy using Azure portal or PowerShell and then import the .bacpac into this empty database.
- Storage behind a firewall is currently not supported.
And if the Migration is for Azure MySQL, please refer to Select the right tools for migration to Azure Database for MySQL,
If you face any error during or post migration, here is the troubleshooting guide.
Pease share your inputs on the above so that we can further assist you, thanks.
Hi @Carolyn Schroeder ,
We are glad to hear that you are able to import bacpac.
We appreciate your effort to share with the community the solution adopted so that members who face similar issues could benefit from the solutions used.
Thanks for using Microsoft Q&A forum.