Azure SQL Database
An Azure relational database service.
6,123 questions
Bacpac file import failing
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 17%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lun, Biondi
0
Reputation points
The ImportExport operation with Request Id 'd1c1c6e5-ae28-45b3-aa81-7c8715658f56' failed due to 'An internal error occurred. Please contact Microsoft support and reference the server name, database name, and operation ID.'.
{count} votes
-
Oury Ba-MSFT 20,626 Reputation points Microsoft Employee2024-02-13T22:00:43.8766667+00:00 @Lun, Biondi
Thank you for reaching out. If the number of tables, indexes and views is large, import model preparation needs a lot of memory and time. Mitigation Import BACPAC using SqlPackage.exe using "/p:Storage=File" option /p: Storage=({File|Memory}) Specifies how elements are stored when building the database model. For performance reasons the default is InMemory. For large databases, File backed storage is required. Syntax sqlpackage.exe /Action:Export /ssn:tcp:<servername>.database.windows.net,1433 /sdn:<source-database-name> /su:<username> /sp:<Password> /tf:.\export.bacpac /p:Storage=File /d:true /df:.\outputlog.log /p:LongRunningCommandTimeout=0 SqlPackage.exe /Action:Import /sf:.\bacpacfile.bacpac /tsn:<servername>.database.windows.net /tdn:<database-name> /p:Storage=File /tu:<username> /tp:********** /d:true /df:.\outputlog.log /p:LongRunningCommandTimeout=0 https://techcommunity.microsoft.com/t5/azure-database-support-blog/using-sqlpackage-to-import-or-export-sql-server-and-azure-sql-db/ba-p/368861 Please let me know if that helps. Regards, Oury -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive 10,321 Reputation points2024-02-14T03:10:35.9366667+00:00 Hi @Lun, Biondi,
Thanks for sharing request id. May I please know which region your server and database belongs to? Thank you! -
Oury Ba-MSFT 20,626 Reputation points Microsoft Employee
2024-02-15T18:00:57.14+00:00 @Lun, Biondi Are you still facing the same issue.? Regards, Oury
Sign in to comment
Sign in to answer