Home Dashboard Directory Help
Search

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


Status: 

Closed


1
0
Sign in
to vote
Type: Suggestion
ID: 774879
Opened: 12/20/2012 9:38:54 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft on 1/16/2013 at 9:02 AM
Bryan,

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).

Thanks,
Adam Mahood
Program Manager
SQL Server Database Systems - Service Management
Sign in to post a workaround.