Press "Enter" to skip to content

Timeouts Importing a Bacpac File

Jose Manuel Jurado Diaz hits one of the three most annoying parts of dealing with bacpac files:

Today, I worked on a service request that our customer got the following error message:¬†Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding¬†importing a bacpac file, in this situation, was at the moment that SQLPackage was enabling (rebuilding) an index, for example,¬†Enabling index ‘IX_MyIndex’…

The other two are, of course, getting one to export without any errors and getting one to export without timing out.