Import Database from bacpac failed

Carolyn Schroeder 186 Reputation points
2023-03-05T19:37:13.48+00:00

I am trying to import a database into an Azure SQL Server from a bacpac. I am using the interface in the Azure portal. I needed to do this for 4 databases. All have failed on "Performs a database extension operation" I can see the databases in SSMS but there are no tables or views. I am moving these database from one subscription to another with different owners.

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
714 questions
0 comments
Accepted answer
  1. ShaktiSingh-MSFT 13,426 Reputation points Microsoft Employee
    2023-03-06T07:15:05.7+00:00

    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.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. risolis 8,701 Reputation points
    2023-03-06T01:24:39.5066667+00:00

    Hello @Carolyn Schroeder

    Thank you for posting this concern on this community space.

    I have read your case scenario description and I would like to double confirm if you are referring to this:

    https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/validate-a-dac-package?view=sql-server-ver16

    Review this other post as well:

    https://learn.microsoft.com/en-us/answers/questions/842138/import-database-to-azure-sql-database-how-to-preve

    Looking forward to your feedback,

    Cheers,

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

    1 person found this answer helpful.
    0 comments