I have a bacpac file for an azure sql database. I am restoring it via the cmd ,
sqlpackage.exe /a:Import /sf:"c:\test\mydb.bacpac" /tsn:"test.database.windows"
/tdn:"restoretestdb" /tu:"testuser" /tp:<pwd> /p:DatabaseEdition="Standard"
/p:DatabaseServiceObjective="S9"
But the problem is every time i try , i getthe error:
Transaction (Process ID <id>) was deadlocked on lock resources with another process and
has been chosen as the deadlock victim. Rerun the transaction.
How can i run the sqlpackage without these errors ?