bacpac restore Issue to Azure DB:Error importing database:Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.

Question

bacpac restore Issue to Azure DB:Error importing database:Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.

Dan J. Meyer 0

Receiving error below when restoring a DB to Azure

*** Error importing database:Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.

Warning SQL0: A project which specifies SQL Server 2019 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12.

Error SQL0: Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.

Vahid Ghafarpour 23,385 Volunteer Moderator

Did you try sqlpackage command?

sqlpackage /a:Import /sf:your_bacpac_file.bacpac /tsn:your_server_name.database.windows.net /tdn:your_database_name /tu:your_username /tp:your_password

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-03T16:02:59.3833333+00:00

Dan J. Meyer

I wanted to check if your issue is resolved or if you need further assistance.

Regards,

Oury
Khushi Verma 0 Reputation points

2023-09-22T17:14:07.32+00:00

Hi, I am facing the same issue while restoring the database to the dev. Can anyone help me?
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-09-27T20:39:38.14+00:00

Khushi Verma,

Please check this link how customers were able to solve it.

Solution might also differ.

https://dba.stackexchange.com/questions/52327/cant-restore-azure-bacpac-into-localdb-with-sqlpackage

Hope that helps.

Regards,

Oury

1 answer

Your answer

Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator

2023-07-21T06:19:32.96+00:00

Did you try sqlpackage command?

sqlpackage /a:Import /sf:your_bacpac_file.bacpac /tsn:your_server_name.database.windows.net /tdn:your_database_name /tu:your_username /tp:your_password
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-08-03T16:02:59.3833333+00:00

Dan J. Meyer

I wanted to check if your issue is resolved or if you need further assistance.

Regards,

Oury
Khushi Verma 0 Reputation points

2023-09-22T17:14:07.32+00:00

Hi, I am facing the same issue while restoring the database to the dev. Can anyone help me?
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2023-09-27T20:39:38.14+00:00

Khushi Verma,

Please check this link how customers were able to solve it.

Solution might also differ.

https://dba.stackexchange.com/questions/52327/cant-restore-azure-bacpac-into-localdb-with-sqlpackage

Hope that helps.

Regards,

Oury

Answer 1

Vahid Ghafarpour 23,385 Volunteer Moderator

Open the BACPAC file and review its contents to ensure it includes only the schema and data of the source database. It should not include user objects like users, roles, logins, or any other objects tied to specific users or logins.

Share via

bacpac restore Issue to Azure DB:Error importing database:Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.

1 answer

Your answer