sqlsql-serverazurebacpac

Sql Server when importing bacpac file receive "Archive file cannot be size 0."


I'm exporting a bacpac file from my Azure SQL Server database to my local file system. Then when I try to import this bacpac file into a local instance of SQL Server I get a "Archive file cannot be size 0." error.

I've tried the import via the GUI Import Data-tier Application functionality as well as executing the SqlPackage.exe via the command prompt. I recieve the same error either way.

Any ideas?

Via the GUI within ssms:

Via the command prompt:


Solution

  • This error turned out to be because there was nothing in the bacpac file. When exporting from Azure it failed the export but still created the file. So I didn't realize it failed.