Editing a .bacpac file

There are times when for whatever reason you just wish you could make a change to a .bacpac file before you import it into Azure. Inside a bacpac file The inside of a bacpac is usually a closed book, you generate it and that is it you have the bacpac file and SQL Server Management…


Lesson Learned #25: Export/Import Azure SQL Database using Azure File Service?

In some situations, we need to import or export our Azure SQL Database using SQLPackage, but, unfortunately, either source and destination file we cannot specify a blob storage, in case that we want to save the file in this storage. For this reason, we have to use a local temporal folder for uploading/downloading the file depending on our needs. However,…


Exported database from Azure SQL failed to be imported to Azure SQL or to local SQL Server

Update: (2018-01-30) – Resolved  DacFX version 17.4.1 has been released, this version contains the fix for all of the behaviors related to the master key. you can download it here to confirm you are using the correct version, verify that the file version of SQLPackage.exe is at least 14.0.3917.1 and follow the instructions here: using sqlpackage…