Bacpac file taking a really long time to import

%3CLINGO-SUB%20id%3D%22lingo-sub-1115411%22%20slang%3D%22en-US%22%3EBacpac%20file%20taking%20a%20really%20long%20time%20to%20import%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1115411%22%20slang%3D%22en-US%22%3E%3CP%3EI%20exported%20my%20db%20from%20Azure%20and%20trying%20to%20import%20into%20my%20local%20SQL%2C%20and%20it%20is%20taking%20a%20really%20long%20time.%20Going%20on%2014%20hours%20and%20it%20is%20not%20completed.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20bacpac%20file%20size%20is%20500Mb.%20The%20extracted%20size%20is%20over%2010Gb%20and%20the%20local%20db%20file%20size%20is%201.5Gb.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20comand%20I%20am%20running%3A%20SqlPackage.exe%20%2Fa%3Aimport%20%2Fsf%3AC%3A%5CTemp%5CProd2Dev_011720.bacpac%20%2Ftsn%3Alocalhost%20%2Ftdn%3AProd2Dev%20%2Fp%3ACommandTimeout%3D0%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20past%20this%20took%20less%20than%20a%20few%20hours%20to%20complete.%20I%20can%20see%20the%20actions%20that%20are%20happening%20and%20it%20is%20moving%20in%20bursts%2C%20such%20as%20deleting%20indexes%20zip%20by%20then%20it%20stops%20for%20~30%20seconds%20and%20then%20zips%20b%20y%20again.%3C%2FP%3E%3CP%3EIn%20the%20past%20this%20has%20always%20zoomed%20by%20in%20the%20command%20window.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20can%20be%20done%20to%20determine%20what%20going%20on%20here%20and%20get%20this%20to%20run%20a%20bit%20faster%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20restart%20on%20a%20different%20server%20with%20the%20%2Fdiagnostics%20on%20and%20it%20is%20stuck%20on%20the%20actions%3A%3C%2FP%3E%3CP%3E%3CEM%3ECreating%20deployment%20plan%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EInitializing%20deployment%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EMicrosoft.Data.Tools.Diagnostics.Tracer%20Verbose%3A%201%20%3A%202020-01-17T10%3A41%3A38%20%3A%20Entering%20ExtensionTypeLoader.LoadTypes().%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

I exported my db from Azure and trying to import into my local SQL, and it is taking a really long time. Going on 14 hours and it is not completed. 

The bacpac file size is 500Mb. The extracted size is over 10Gb and the local db file size is 1.5Gb.

 

The comand I am running: SqlPackage.exe /a:import /sf:C:\Temp\Prod2Dev_011720.bacpac /tsn:localhost /tdn:Prod2Dev /p:CommandTimeout=0

 

In the past this took less than a few hours to complete. I can see the actions that are happening and it is moving in bursts, such as deleting indexes zip by then it stops for ~30 seconds and then zips b y again.

In the past this has always zoomed by in the command window.

 

What can be done to determine what going on here and get this to run a bit faster?

 

I did restart on a different server with the /diagnostics on and it is stuck on the actions:

Creating deployment plan

Initializing deployment

Microsoft.Data.Tools.Diagnostics.Tracer Verbose: 1 : 2020-01-17T10:41:38 : Entering ExtensionTypeLoader.LoadTypes().

 

 

 

0 Replies