Export Azure SQL DB Error: “Missing the required ‘administratorLogin’ parameters for ImportExport operation.”

Few days ago, I have been working on an issue that customer trying to Export Azure SQL Database using Azure Portal, facing this Error Message: ErrorCode: 400 ErrorMessage: Missing the required ‘administratorLogin’ parameters for ImportExport operation. Symptom: Customer is using Google Chrome browser connect to Azure Portal and trying to Export Azure SQL DB, frequently…


Export Azure SQL Database to local path

We noticed a few requests come to our support queue asking for a feasibility to export Azure SQL Database to local path directly, so following steps below to build  PowerShell script that can do that job to copy Azure SQL Database to another db for consistency, then export Azure SQL Database to blob storage, later…


What will happen with CATALOG_COLLATION and Case Sensitive vs Case Insensitive

One of the options available when creating a database is the CATALOG_COLLATION, by default this is going to be SQL_Latin1_General_CP1_CI_AS , even if you take the trouble of specifying a database collation , the catalog collation will be SQL_Latin1_General_CP1_CI_AS unless you say otherwise. If you do not set this parameter it will not use the…


REST API Sample for exporting a database

While working on an Azure SQL Database support case, I needed to provide a REST API sample for exporting a database. I struggled a bit to get it to work, as the syntax is not really intuitive and requires creating an Azure AD application. To save you from the same struggle, here is the sample…


PolyBase export of datetime values does not use DATE_FORMAT

This topic came up on a recent support case I had worked on. The customer had stored the data in an Azure SQL Data Warehouse database, but needed to move it into Azure blob storage for consolidating data from different sources. This also required to write the datetime values in a specific format. The idea…


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…


BACPAC Export failing with Unable to reconnect – Timeout expired

I had a support case recently where the export of a SQL Server database into a BACPAC file was failing. The first attempt was done through SQL Server Management Studio 2016, by right-clicking the database -> Tasks -> Export Data-Tier Application. Another attempt using the sqlpackage.exe command-line tool showed the identical results though. The following operations…