Data is bulk loaded at this point in deployment execution #SQL72012 #SQL72016 #SQL72045 #Execution Timeout Expired #Azure SQL to On-promise

Last week I got a task to create a local copy from an Azure SQL Database. It was fine few months back. However, I got below error message saying “Data is bulk loaded at this point in deployment execution”.


TITLE: Microsoft SQL Server Management Studio
------------------------------
Could not import package.
Warning SQL72012: The object [nav-uat_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Warning SQL72012: The object [nav-uat_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Error SQL72016: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Error SQL72045: Script execution error.  The executed script:
/*
Data is bulk loaded at this point in deployment execution
*/
 (Microsoft.SqlServer.Dac)
------------------------------
ADDITIONAL INFORMATION:
Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServ





Solution


You can use the latest version of the SqlPackage.exe command line tool with a larger timeout.
DacFX supports various database deployment and management scenarios for SQL Server and Microsoft Azure SQL Databases including extracting / exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on - premise SQL Server to Microsoft Azure. This functionality is exposed via the DACFx managed API. DACFx can target SQL Server 2008, 2008R2, 2012, 2014, 2016 CTPs and Microsoft Azure SQL Databases. DACFx also provides the command-line utility SqlPackage.exe for creating and deploying.dacpac and .bacpac packages. DACFx supports scenarios provided by SQL Server client tooling including SQL Server Data Tools and SQL Server Management Studio.
 You download and use the latest DacFx release from the below link:

https://www.microsoft.com/en-us/download/details.aspx?id=51941

NOTE: If you are on an x64 machine, you will need to install both the x64 and x86 versions of the MSIs above.

After you have installed Microsoft® SQL Server® Data-Tier Application Framework

There are some commands you have to execute
Step 1
Run Command as an Administrator. Use cd command to change the path





This will change the path from system32 to the path you want to execute the .exe.


Step 2

Execute the command.
Use the below example command line:
sqlpackage.exe /Action:Import /tsn:servername /tdn:databasename /tu:adminuser /tp:adminpassword /sf:export.bacpac /p:CommandTimeout=1800

sqlpackage.exe /Action:Import /tsn:MBS /tdn:nav-uat /tu:sa /tp:password /sf:"D:\MBS\MBSUAT11042019.bacpac" /p:CommandTimeout=1800