Home Dashboard Directory Help
Search

DacFx 3.0 performs poorly when dacpac has a medium-large schema by mistermanager


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 811990
Opened: 12/19/2013 7:22:27 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

I see no option for windows 8, but I am on windows 8 with Visual Studio 2012 Ultimate.

When using the DacFx 3.0 API (http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dac.aspx) the DacServices.Deploy and DacServices.GenerateDeploymentScript commands perform poorly when a dacpac is of a reasonable size. This is a curious problem as it is my understanding that DacFx 3.0 is backed up with dbSqlPackage, which has no issue whatsoever with the exact same dacpac.

A script generation or deployment can take as much as 20 minutes to run, which is obviously unacceptable. If this were addressed it would make the DacFx 3.0 API an extremely powerful tool.
Details
Sign in to post a comment.
Sign in to post a workaround.