When I try to restore a BACPAC created by Sql Backup and FTP I get a “File contains corrupted data” error.
I’m using SqlPackage.EXE to restore the BACPAC to a local SQL Server. If I use SqlPackage to create the BACPAC, the restore works.
Big Picture: we have an Azure SQL database that is used for a live website. We backup the database to a local server using Sql Backup and FTP every night. We want the ability to restore the BACPAC file to a local SQL Server for website development and testing purposes.