Search

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

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)
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 (expand)

Product Language

English

Category

Data-Tier Application Framework (Dac, DacFX, DACPAC)

Proposed Solution

Expose an API method to query a SQL Server Instance for a list of installed DACPACs (I don't even care if there are filter methods as that can be done by LINQ on the clientside)

Primary Benefit

Faster Development

Other Benefits

 

Virtualization

 
File Attachments
0 attachments
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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement