Upgrading Dacpacs With Dacfx 3.0 Api - How To Inspect Current Dac Version Of An Existing Database?
I am currently rewriting my team's database deployment Powershell script to use DACFx 3.0 API instead of 2.0. I've managed to get the DACPAC upgrade to work successfully, using the
Solution 1:
Just got a reply from MSFT:
The Dac 3.0 API doesn't have this capability as you've discovered. Use T-SQL to select this data directly from dbo.sysdac_instances.
It seems like it is in fact the only way: http://msdn.microsoft.com/en-us/library/ee240830.aspx So I'll query off that view for now, although I'd really love to see it brought into the DACFx API at some point. Note that the view dbo.sysdac_instances is in the masters database, as msdb does not exist in SQL Azure.
Post a Comment for "Upgrading Dacpacs With Dacfx 3.0 Api - How To Inspect Current Dac Version Of An Existing Database?"