SSDT - Comparing dacpac to dacpac never completes - by eajolley

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 780065 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 2/26/2013 4:48:50 PM
Access Restriction Public


We have a database project for which we are trying to compare the output dacpac file to another dacpac file that is extracted from a database.  Using VisualStudio2010, we select the Source and Target schemas and click Compare but the Compare never completes.  The progress bar shows: Loading schema from source and target..., but never progresses from there.  For us, it is isolated to this one project/database dacpac comparison.  We have other project/database pairs for which the schema compare completes successfully. 

We've had the same result using VisualStudio2012 and every machine we've tried it on.  We have the latest SSDT update from December 2012.
Sign in to post a comment.
Posted by Microsoft on 2/27/2013 at 10:38 AM
Hey eajolley,

Thanks for reporting this issue around schema comparison hanging when loading the models from source/target dacpacs. We have had other reports of this issue and have since taken a fix for the root cause. Look for this issue to be fixed in an upcoming release of DACFx, the engine that sits underneath SSDT and powers Schema Compare.

Adam Mahood - Program Manager - SQL Server Database Systems