Enhance DACFX API to allow querying for installed DACPACs - by Bryan Hinton - HQC

Status : 


Sign in
to vote
ID 774879 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/20/2012 9:38:54 AM
Access Restriction Public


We use DACPACs to install the underlying database that multiple applications rely on.  Currently we can use the API to deploy the updated dacpac, but for the applications we would like to use the api to find out the currently installed version - since that isn't exposed through the API we have to connect to the DB and query the msdb.dbo.sysdac_instances (in a different spot for SQL Azure) instead.  
Sign in to post a comment.
Posted by Microsoft on 1/16/2013 at 9:02 AM

Thank you for the feedback on adding a mechanism to the DACFx API to allow querying for all of the registered DACs on an instance. There is now an item for this issue on our backlog and will be considered for inclusion in a future release of the DACFx redist.

The current solution is, as you mention query msdb.sysdac_instances_internal table (master.sysdac_... in Azure).

Adam Mahood
Program Manager
SQL Server Database Systems - Service Management