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…


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…


Unexpected Select queries seen in the Performance Overview of the Azure Portal

Scenario: During a time of low database activity, you may see an unexpected spike of DTU consumption in the performance graphs on the Azure Portal. Drilling into it through the Performance Overview and Query Performance Insight feature, you identify some queries which you do not recognize. The overall DTU consumption for them is rather low…


BACPAC: Could not load schema model from package

When trying to import a BACPAC file, you could run into the following error. Count not load schema model from package. (Microsoft.SqlServer.Dac) Additional Information: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid…

5