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

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.

Answer 1

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.