Error trying export SQL Azure database to BACPAC file

Question

I weekly backup to BACPAC file using Az through Windows PowerShell.

About a few weeks ago, one of the databases started to display an error when exporting (export through Azure Portal or PowerShell):

Could not export schema and data from database. One or more errors occurred. One or more errors occurred. One or more errors occurred. One or more errors occurred. One or more errors occurred. Failed to convert parameter value from a Double to a Byte. Value was either too large or too small for an unsigned byte.

I tried to restore a week-old backup and export it, everything was successful. I also ran ssdt compare and found no differences between the bases.

However, the export using SqlPackage.exe proceeds without errors.

Any help would be helpful, thanks in advance!

Answer 1

Hello @Dmitry Mikheev , Thanks for reporting this issue. We apologize for the inconvenience that this has caused you. We have identified this as a dacfx bug which was introduced by our recent deployment. We are in process of rolling back the changes which caused this error. Could you please retry in about a week, when the rollback will be deployed to all Azure regions? Until then, using sqlpackage.exe would be the best workaround.

Thanks,
shreya