• Kill database issue in database restore
  • Download two set of .backpac or move one copy into you vm.
  • change the extension of .backpac to zip.
  • Extract it or if you dont have space just open it in Zip or winrar.
  • Copy only model.xml in your local hard drive.
  • Open it in notepad++
  • Search and remove all nodes Grant.KillDatabaseConnection.Database
  • Save the xml file.
  • Delete the extracted zip file.
  • Copy the extracted and modified model.xml into same folder where you place the .backpac in your vm Hard drive.
  • Apply the same command with additional key words /ModelFilePath (/mfp)
  • mfp means file path model.
  • The complete file will be look like
  • SqlPackage.exe /a:import /sf:c:\\temp\\BabaKaTullo.bacpac /tsn:localhost /tdn:axdb5 /p:CommandTimeout=500000 /ttsc:True /ModelFilePath:G:\\Temp\\model.xml