May 27, 2024, 2:58 a.m. | Eduardo Silva Rossi

DEV Community dev.to

Recently, while making a copy of production database to my development environment, I came across an unusual error when importing the .bacpac file using SqlPackage:



*** Error importing database: Could not import package.                                   
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 4630, Level 16, State 1, Line 1 The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server. Alternatively, use the server level 'ALTER ANY CONNECTION' permission.
Error SQL72045: Script execution error.
The executed script: …

copy core data database development environment erp error file fix import making microsoft package permission production provider server sql while

Senior Data Engineer

@ Displate | Warsaw

Lead Python Developer - Generative AI

@ S&P Global | US - TX - VIRTUAL

Analytics Engineer - Design Experience

@ Canva | Sydney, Australia

Data Architect

@ Unisys | Bengaluru - RGA Tech Park

Data Architect

@ HP | PSR01 - Bengaluru, Pritech Park- SEZ (PSR01)

Streetlight Analyst

@ DTE Energy | Belleville, MI, US